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 -- |
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) |