View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Naveen Naveen is offline
external usenet poster
 
Posts: 100
Default 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