| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
