Excel 2007 Formula help

[yovation]

Hello Everyone,

RE: Excel 2007

I am new to this group and have only been using excel for a few
years. I am reading "Excel 2007 the missing manual" to help further
my understanding of the program.


I have a question about how to format a formula:

Information:
Contents of A2 = 25013.JPG

What I would like as the end result:

<a href="graphics/00000001/hi-rez/25013.jpg">
<img src="graphics/00000001/hi-rez/25013.jpg" width="150">
</a>

What I have so far:

=IF(A2>0,"<a href=graphics/00000001/hi-rez/"&LOWER(A2),"""")

I just don't know where to go from here?

Thank you for your help.

David

 

[Bernie Deitrick]

David,

=IF(A2>0,"<a href=""graphics/00000001/hi-rez/"&LOWER(A2) & """>","")
=IF(A2>0,"<img src=""graphics/00000001/hi-rez/" &LOWER(A2) & """ width=""150"">","")

HTH,
Bernie
MS Excel MVP

 

[yovation]

Thank you Bernie