Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? 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 |
#2
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink in an IF statement
When Excel see HYPERLINK in a formula, it makes the cell a hyperlink
=(IF(1=1,1,HYPERLINK(""))) is a hyperlink even if the link can never be executed. If you use something like: =IF(A10="","Enter ID",B10) and put the HYPERLINK() in B10, the link will be visible if A10 allows, but not "follow-able" -- Gary's Student "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink in an IF statement. | Excel Worksheet Functions | |||
answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
How can I use HYPERLINK in a conditional statement between sheets | Excel Worksheet Functions |