Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Imagens inside an Excel Cell

  Asked By: Hamish    Date: Jan 26    Category: MS Office    Views: 852
  

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.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Renee Lane     Answered On: Jan 26

If Wingdings doesn't have enough smilies, make your own! With 'Private
Character Editor' in at least Windows XP (reached by :
Start|Run|eudcedit )
Perhaps you can copy the Wingdings file, giving it another name and
edit a character within this new font  file as your 4th smiley?

 
Didn't find what you were looking for? Find more on Imagens inside an Excel Cell Or get search suggestion and latest updates.




Tagged: