Hyperlink in an IF statement.
 

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?


--
martix
------------------------------------------------------------------------
martix's Profile: http://www.excelforum.com/member.php...o&userid=35157
View this thread: http://www.excelforum.com/showthread...hreadid=549212

Hyperlink in an IF statement.
 

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),"Ente r ID"),
HYPERLINK("http://microsoft.com","Click here!"))

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

martix wrote:

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?

--
martix
------------------------------------------------------------------------
martix's Profile: http://www.excelforum.com/member.php...o&userid=35157
View this thread: http://www.excelforum.com/showthread...hreadid=549212

--

Dave Peterson