| 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? -- martix ------------------------------------------------------------------------ martix's Profile: http://www.excelforum.com/member.php...o&userid=35157 View this thread: http://www.excelforum.com/showthread...hreadid=549212 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
| How can I use HYPERLINK in a conditional statement between sheets | Excel Worksheet Functions | |||
Linear Mode
