If function with images
 

I'm trying that my excel cell shows one of 3 images according to a if
condition.

Something like:

If value in B1A1 in cell C1 appears image 1
If value in B1<A1 in cell C1 appears image 2
If value in B1=A1 in cell C1 appears image 3

How can I built this?

Thanks

If function with images
 

Paste the following formula in C1

=HYPERLINK(IF(B1A1,"C:\Image1.jpg",IF(B1<A1,"C:\I mage2.jpg","C:\Image3.jpg")),"Image")


Replace "C:\Image1.jpg" with your image and in the same way image2, image3

*** Please do rate ***






"Pedro Serra" wrote:

I'm trying that my excel cell shows one of 3 images according to a if
condition.

Something like:

If value in B1A1 in cell C1 appears image 1
If value in B1<A1 in cell C1 appears image 2
If value in B1=A1 in cell C1 appears image 3

How can I built this?

Thanks

If function with images
 

Naveen,

The image as to be in the worksheet and as to be displayed not as an hyperlink

I was looking for something that can automaticlly show the image without
leaving the worksheet where I'm working.

Do u think u can help me?

"Naveen" escreveu:

Paste the following formula in C1

=HYPERLINK(IF(B1A1,"C:\Image1.jpg",IF(B1<A1,"C:\I mage2.jpg","C:\Image3.jpg")),"Image")


Replace "C:\Image1.jpg" with your image and in the same way image2, image3

*** Please do rate ***






"Pedro Serra" wrote:

I'm trying that my excel cell shows one of 3 images according to a if
condition.

Something like:

If value in B1A1 in cell C1 appears image 1
If value in B1<A1 in cell C1 appears image 2
If value in B1=A1 in cell C1 appears image 3

How can I built this?

Thanks

If function with images
 

Pedro

Check out John McGimpsey's site for code not involving Hyperlinks.

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



Gord Dibben MS Excel MVP

On Fri, 25 Aug 2006 07:40:03 -0700, Pedro Serra
wrote:

Naveen,

The image as to be in the worksheet and as to be displayed not as an hyperlink

I was looking for something that can automaticlly show the image without
leaving the worksheet where I'm working.

Do u think u can help me?

"Naveen" escreveu:

Paste the following formula in C1

=HYPERLINK(IF(B1A1,"C:\Image1.jpg",IF(B1<A1,"C:\I mage2.jpg","C:\Image3.jpg")),"Image")


Replace "C:\Image1.jpg" with your image and in the same way image2, image3

*** Please do rate ***






"Pedro Serra" wrote:

I'm trying that my excel cell shows one of 3 images according to a if
condition.

Something like:

If value in B1A1 in cell C1 appears image 1
If value in B1<A1 in cell C1 appears image 2
If value in B1=A1 in cell C1 appears image 3

How can I built this?

Thanks

Gord Dibben MS Excel MVP