Hyperlink issue

[dukiedog2]

I have "developed " a database for work. The user will enter a value to display results. Among the 10 or so results I want to insert a word file that is located on another sheet. However not all results have a file, but will have a zero instead. SO on the results display cell I have an IF( location="0" , " No link available", Hyperlink( location , "click for link")) However I always get a click here even if the cell value in the IF staement is true. Why does it always try to give a hyperlink???

 

[nbrcrunch]

known issue. no workaround that I know of.

 

[silkfire]

Try:

=IF(TEXT(location;"?")="0","No link available",HYPERLINK(location,"click for link"))

 

[nbrcrunch]

Silkfire: As I understood the poster's issue, no matter if the IF statement resolves to the TRUE or FALSE part of the statement, when you hover over the cell containing the IF statement, it always indicates a hyperlink is present. Your formula does that as well.

 

[dukiedog2]

That is correct nmbr... This sux

 

[silkfire]

Can you send me your document to my email and I'll try to resolve it: endarion [at] gmail [.] com?