HYPERLINK() Help

[PCLIVE]

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,HYPERLINK(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





--

 

[Dave Peterson]

I have no idea why it behaves this way--but it does. I'm sure you could call MS
and ask <vbg>.

But when I want to avoid that "cannot open..." error message, I'll do something
like:

=IF(B1=C1,HYPERLINK("#a1","No Link"),HYPERLINK("http://www.cox.net","Test"))

Where A1 is the cell with the formula. So it's really a link to nowhere <vvbg>.

For your second formula, I'd use this:

=IF(Sheet1!D5="",HYPERLINK("#a1",""),
IF(Sheet1!F5="",HYPERLINK("#a1",Sheet1!D5),
HYPERLINK(Sheet1!F5,"Test")))

(Formula is still in A1.)

If you have URLs in sheet1!f5, then don't do this.

But if you really wanted to link to that cell, you'd want to use:

=IF(Sheet1!D5="",HYPERLINK("#a1",""),
IF(Sheet1!F5="",HYPERLINK("#a1",Sheet1!D5),
HYPERLINK("#Sheet1!F5","Test")))