How to embed an image in a cell by URL reference?

**jason-w** · 09-20-2011, 05:57 PM

I am trying to add an image reference (using a URL or network drive path) within the below shown formula (in place of the exclamation mark) but haven't been able to.

=IF(C105<5,"!","")

I am assuming there must be a relatively simple way to do this, but maybe not. Any help anyone can offer is much appreciated. Thx.

Jason

**martindwilson** · 09-20-2011, 06:03 PM

us the hyperlink function

=IF(C105<5,
HYPERLINK("http://www.excelforum.com/excel-general/793153-how-to-embed-an-image-in-a-cell-by-url-reference.html","excel forum"),"")

=HYPERLINK("C:\Documents and Settings\Martin Wilson\My Documents\My Pictures\martin.jpg","my pic")

**jason-w** · 09-20-2011, 06:18 PM

Thanks, but I'm actually intending for the image to display within the cell rather than open/display in a new browser window when the condition is satisfied.

Is there a way to do that, if you know what I mean?