Forum Discussion
Solved
Display images in Excel
Is it possible to display difference images in Excel using function such as IF. Such as IF test is TRUE then display an image and if it is FALSE then display nothing.
Hello,
yes, that's possible, if you use a named range and an image shape. I attached a sample file to this post. The sample file includes two sheets. The second one has an image centered in one cell (!) and another cell with the same size, which is empty. Then, I created a named range Image with the formula: =INDEX(Images!$C$3:$C$4;Display!$D$3;1). D3 from the sheet Display contains the simple formula =IF(C3;1;2) and C3 your value TRUE/FALSE. You can adapt this to your needs, of course. Then I added an image Insert/Pictures (pick anyone). When the image is inserted, click on it and in the formula bar, type =Image + Enter. That's it.
Best regards,
Mourad
Hello,
yes, that's possible, if you use a named range and an image shape. I attached a sample file to this post. The sample file includes two sheets. The second one has an image centered in one cell (!) and another cell with the same size, which is empty. Then, I created a named range Image with the formula: =INDEX(Images!$C$3:$C$4;Display!$D$3;1). D3 from the sheet Display contains the simple formula =IF(C3;1;2) and C3 your value TRUE/FALSE. You can adapt this to your needs, of course. Then I added an image Insert/Pictures (pick anyone). When the image is inserted, click on it and in the formula bar, type =Image + Enter. That's it.
Best regards,
Mourad
- Mourad,
I understand how to create named range Image using FORMULA -> DEFINE NAME but not clear about which sheet I should create that named range image and where to write the INDEX formula. I tried to write your INDEX formula in another cell of the Display sheet but I do not get the image.
Could you please advice.- Using Name Manager, your named range IMAGE have Workbook scope that the Index formula is written on those named range. I have no idea about how to reproduce the image on the Display sheet.
In addition, I inserted a picture and write =image on that picture. That picture does not displayed as it should after =image is written. A sketch of display screen and a computer is displayed in place of the picture. So I am completely lost!- Finally, after lot of trial error, I am now know how it works.
I have to insert pictures to each cells of the named range and write =image to each of them. In order to display the result of the Index function, I have to insert any image where I want to display it and write =image on it.
It was very hard to understand how it works, Thank a lot.
Wow, this is quite new for me. I got to take time to learn of how it works.
Thank you so much for your help.
