show picture in cell if the ``if`` formula is true

[bjorn1404]

Hello everyone,

i want to show a picture in a cell if the outcome of the if formula is true.

example

if(a1=apple;picture of apple;""

is this posible, and how ? thanks in advance!

 

[DRSteele]

Sure. Excel 365 has a new function called IMAGE. The images won't show here in the Forum's sample sheet, but put it in your workbook and presto.

Book1
	D	E	F
1			CGY
2
3
4
5
6	ANA	https://upload.wikimedia.org/wikipedia/en/thumb/7/72/Anaheim_Ducks.svg/220px-Anaheim_Ducks.svg.png
7	ARI	https://upload.wikimedia.org/wikipedia/en/thumb/9/9e/Arizona_Coyotes_logo_%282021%29.svg/220px-Arizona_Coyotes_logo_%282021%29.svg.png
8	BOS	https://upload.wikimedia.org/wikipedia/en/thumb/1/12/Boston_Bruins.svg/220px-Boston_Bruins.svg.png
9	BUF	https://upload.wikimedia.org/wikipedia/en/thumb/9/9e/Buffalo_Sabres_Logo.svg/220px-Buffalo_Sabres_Logo.svg.png
10	CGY	https://upload.wikimedia.org/wikipedia/en/thumb/6/61/Calgary_Flames_logo.svg/220px-Calgary_Flames_logo.svg.png
11
Sheet1

Cell Formulas
Range	Formula
F3	F3	=IF(F1="CGY",F10)
F6:F10	F6	=IMAGE(E6)