For =IF function to display a picture as its value.

[Tami W]

I would like to be able to insert a picture into a formula
so that when I use the if= formula the answer can display
a picture instead of a word or number.

 

[Frank Kabel]

Hi
this is not possible with formulas but would require VBA. But maybe you
can live with using an IF statement in combination with the HYPERLINK
function. e.g.
=IF(A1="value",HYPERLINK("C:\temp\picture.jpg"),"")