If function with images

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Something like:

If value in B1>A1 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
 
Paste the following formula in C1

=HYPERLINK(IF(B1>A1,"C:\Image1.jpg",IF(B1<A1,"C:\Image2.jpg","C:\Image3.jpg")),"Image")


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

*** Please do rate ***
 
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:
 
Pedro

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

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



Gord Dibben MS Excel MVP

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:
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top