Posted to microsoft.public.excel.worksheet.functions
|
|
Hyperlink in an IF statement
See your first post.
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?
The other threads is a bug... dunno what happened
--
martix
------------------------------------------------------------------------
martix's Profile: http://www.excelforum.com/member.php...o&userid=35157
View this thread: http://www.excelforum.com/showthread...hreadid=549213
--
Dave Peterson
|