The cell A1 can vary from 0 to 10.
I have four jpeg images (four types of smiley faces): 1.jpeg, 2.jpeg,
3.jpeg and 4.jpeg.
I'd like to do something like this with the cell A2:
=if(a1<2,5;1.jpeg;if(a1<5;2.jpeg;if(a1<7,5;3.jpeg;4.jpeg)))
Is this possible without using a macro?
I tried to use the smiley faces that Wingdings font has (letters J, K
and L), but there are only three smiley faces. I need four.