Can an IF statement insert an picture?
 

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!

Can an IF statement insert an picture?
 

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

if range("a1")=1 then
ActiveSheet.Pictures.Insert("C:\yourfolder\yourpic ture.jpg")
--
Don Guillett
SalesAid Software

"Iriemon" wrote in message
...
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!

Can an IF statement insert an picture?
 

Maybe something for you at John McGimpsey's site.

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


Gord Dibben MS Excel MVP



On Mon, 11 Sep 2006 05:43:02 -0700, Iriemon
wrote:

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