I'm attempting to make a formula that will toggle a hyperlink on or off depending on the argument. Basically, I want to make it argue the following:
If there is text in (Tab A, Cell A), then create a hyperlink with the title (Text of Tab A, Cell A) that links to (Tab B, Cell A). If no text is present in (Tab A, Cell A), then just put the text "Not in Use" with no hyperlink.
I was attempting this formula, but it's not quite working. As long as there is text in SETUP!D39
, it displays the text and activates the hyperlink, but the text is not blue or underlined. If there is no text in SETUP!D39
, then it displays the text (Not In Use) properly, but the hyperlink is still there and gives the error "Cannot open the specified file". I'm pretty sure it's just a syntax error in my formula, but I can't figure it out:
=IF(ISTEXT(SETUP!D39),HYPERLINK("#'DEDICATED FUNDS (10)'!A1", (SETUP!D39)), "(NOT IN USE)")
So my questions are:
- Any idea why the hyperlink is not turning blue and underlining?
- Any suggestions on why the hyperlink still exists in the second argument?
Any help is greatly appreciated.