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