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

  • Thread starter Thread starter Tami W
  • Start date Start date
T

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.
 
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"),"")
 
Back
Top