Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HYPERLINK() Help
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 -- |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HYPERLINK() Help
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"))) PCLIVE wrote: 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 -- -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Hyperlink from one sheet to the hyperlink on another | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |