Formulas results that show Images

[burt0na]

Hi guys,

I am looking to produce a formula whereby depending on the result an image is inserted.

For Example: I have 3 images I want to represent good, bad and indifferent, good would be anything above 70%, indifferent 30%-70% and bad below 30% but rather than the formula showing the figure id like a image to show.

I dont know if this is possible with a formula, it maybe a piece of code but its Excel so im sure it is

Any help would be appreciated

Andy

 

[burt0na]

That looks brilliant Andrew, how would I do this in Excel 2003? As the picture doesnt seem to embed itself to the cell and the paste functions arent as Jazzy as later versions of Excel in order to link the two cells?

In answer to your question Jon I just get the following -#REF!
<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 94.5pt; mso-height-source: userset" height=126><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 94.5pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl24 height=126 width=64 align=middle x:err="#REF!">


</TD></TR></TBODY></TABLE>

 

[Andrew Poulsom]

In Excel 2003 copy the cell, select the target cell then hold down Shift and choose Edit|Paste Picture Link.

 

[burt0na]

It works!

Fantastic, thanks Andrew!!

One last question (I promise). Rather than using number 1,2,3 etc to fetch the correct picture I will be working out a formula.

For example the formula works out to be 30%, how could i get this to show the correct picture?

 

[Andrew Poulsom]

Can't you use a formula like?

=IF(A1>70%,1,IF(A1>30%,2,3))

 

[burt0na]

Brilliant!

Thanks for all your help, both of you!

Now I can tell my boss I did it myself