Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EXCEL won't show picture | Excel Discussion (Misc queries) | |||
Show gridlines or cell borders on top of a picture | Excel Discussion (Misc queries) | |||
Can an IF statement insert an picture? | Excel Discussion (Misc queries) | |||
Declear which picture I want to show and not?! | Excel Discussion (Misc queries) | |||
Declear which picture I want to show and not?! | Excel Worksheet Functions |