Display images through formula

[David McRitchie]

Hi Mary,
Not that I'm aware of. You can have your logic result in
HTML coding and then convert the Excel to HTML with
a conversion to HTML that is ignorant of HTML tags and symbols..
An example of an HTML ignorant conversion is my Excel to HTML
http://www.mvps.org/dmcritchie/excel/xlhtml.htm
You would not be able to use the HTML wizard include with
Excel for File, Save As since you would get what you see in
Excel.

B1: '002-051
Resultant content of cell D1 displays as
<IMG SRC="../image/cat002051.jpg" alt="002-051">
from something like
=IF(B1<>"","<IMG SRC=""../image/cat" & B1 &
".jpg"" alt=""" & B1 & """>", "")

Likewise, you could convert the Excel document to Word look
for the phrase "Merge Pictures and Words" in my Mail Merge
document for some links to related pages.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Macros: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mary" <in...@discoverthis.com> wrote in message news:436701c28de2$c12332f0$8df82ecf@TK2MSFTNGXA02...
> Is there a way to have an image displayed through an
> excel formula. I have several item numbers and
> associated gif images and I am looking for a formula or
> method that will display the images without having to
> manually insert them.
> Thanks.

[toddi]

Yes, I've often wanted to do that too, in order to shuffle pictures around
according to instructions (or randomly).
I guess the problem is that pictures are not *in* cells (as the contents)
but just hovering over the grid.
Tod