Why does this cause the cell to have a hyperlink status? By this I mean,
when you hover the mouse pointer over the cell, it changes to a hand
indicating that the cell is a hyperlink. Additionally, if you click on the
cell it states, "Cannot open the specified file."

=IF(1=1,"No Link",HYPERLINK("http://www.cox.net","Test"))

Since 1 does, in fact, equal 1, then would thing the result would be "No
Link" without a hyperlink. While the cell displays correctly, it still has
hyperlink functionality.

While the more simpler formula, above, exhibits the same behavior, my actual
formula is:

=IF(Sheet1!D5="","",IF(Sheet1!F5="",Sheet1!D5,HYPE RLINK(Sheet1!F5,"Test")))

This test to see if there is something in column F of Sheet1. If there is,
then it applies a hyperlink as appropriate. But if there is nothing in the
F column, then it should just return the value in column D, without a
hyperlink.

Any ideas?
Paul





--