Hyperlink in an IF statement.

  • Thread starter Thread starter martix
  • Start date Start date
M

martix

So I make this function
=IF(A10="","Enter ID",HYPERLINK(some formula that determines the
id,"Click here!")

And it make the "Enter ID" also a link! Why and how do I set it so only
the "false" part of the statement is made a link?
 
I have no insight on why it works that way, but it does.

I'd use this instead, though:

=IF(A10="",HYPERLINK("#"&CELL("address",A10),"Enter ID"),
HYPERLINK("http://microsoft.com","Click here!"))

(replace the microsoft.com link with your formula.)
 
Back
Top