Can an IF statement insert an picture?

[Guest]

Is there any way to use an IF statement to have it return an picture? Example:

= IF(a1=1,xxxxxx.jpg,"")

If cell a1 =1, insert a picture, otherwise leave cell blanK.

Thanks!

 

[Don Guillett]

A formula may only return a value. You need a macro, Try

if range("a1")=1 then
ActiveSheet.Pictures.Insert("C:\yourfolder\yourpicture.jpg")

 

[Gord Dibben]

Maybe something for you at John McGimpsey's site.

http://www.mcgimpsey.com/excel/lookuppics.html


Gord Dibben MS Excel MVP

Is there any way to use an IF statement to have it return an picture? Example:

= IF(a1=1,xxxxxx.jpg,"")

If cell a1 =1, insert a picture, otherwise leave cell blanK.

Thanks!

Gord Dibben MS Excel MVP