Can I use an IF statement to show a picture?

  • Thread starter Thread starter Mikey C
  • Start date Start date
M

Mikey C

Hi all,

I am using the following IF statement to show the % increase in costs,
only if it is 10% or higher than the running average. If not the cell
stays blank.

=IF(AND(J11>10%,J11<>""),J11,"")

Now .... could anybody tell me how I could change the above formula so
that instead of showing the % increase from cell J11, it will display
a picture of an unhappy face? Sounds a bit daft but it does capture
peoples attention!

The image will probably be a bitmap or jpeg

Thanks folks - much appreciated :-)

Mike
 
If all you wanted to display is faces (no numbers), then
"J"
"K"
"L"
will display:

happyface
neutralface
sadface

in the Wingding font
 
Did somebody just reply to my post? It says I have a response but I
can't see the message!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using an IF statement to display an image ... 2
7+ Nested if Statement using indirect function 6
Can an IF statement insert an picture? 2
Help Please with If statement / vlookup 9
Getting an average using if statement 3
The Last of Us - Part I (PC) 6
Formula not recognizing reference to "" in IF statement 2
Iff statement to show pictures 4

Back
Top