Billznik wrote:
I'm trying to use this function =IF(TRUE,A1,HYPERLINK("")) to simply
have one cell show the other cell which contains a hyperlink. When I
use this code, the text shows, but the hyperlink does not and when I
click, it says site not found. How can I get this to work?



Hi Billznik,

I think you could find useful these pages about hyperlinks in Excel:

http://office.microsoft.com/en-gb/as...995161033.aspx

http://office.microsoft.com/en-gb/as...091161033.aspx

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy