Can I use an IF statement to show a picture?
 

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(J1110%,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

Can I use an IF statement to show a picture?
 

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

happyface
neutralface
sadface

in the Wingding font
--
Gary''s Student - gsnu200723


"Mikey C" wrote:

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(J1110%,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

Can I use an IF statement to show a picture?
 

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

Can I use an IF statement to show a picture?
 

http://groups.google.co.uk/groups?so...icture %3F%22
--
David Biddulph

"Mikey C" wrote in message
ups.com...
Did somebody just reply to my post? It says I have a response but I
can't see the message!