On Jul 20, 8:29*am, FGM wrote:
I am having trouble in excel vs2002 with an if statement that I am trying to
build a hyperlink in.
If D4 if blank I want it to remain blank but if it is not I want to build a
http link.
It comes back but just as text. *Doing a find replace after for the = sign
makes it a formula and works. *Would like to do it without the find replace.
thanks..

=IF($D4="","","='"&$A$1&"["&F$3&TEXT($D4,"m-d-yy")&".xls]Daily
Schedule'!$AT$54")

FGM,

Did you try embedding the HYPERLINK function in your IF function?

Best,

Matthew Herbert