| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with If function
I have successfully used the following to create a dynamic link:
=HYPERLINK(INDIRECT("'" & $A$12 & "'" & "!" & "A2")) The problem is that if there is no value in the cell referenced for the dynamic link, it returns that annoying #ref! So, I thought I would be smart, and change it to: =IF(A12="","",HYPERLINK(INDIRECT("'" & $A$12 & "'" & "!" & "A2"))) This got of the #ref!, sure enough, but now, gives an error and says that the reference is invalid. Thoughts? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function problems | Excel Worksheet Functions | |||
| If then Function Problems | Excel Worksheet Functions | |||
| problems with if function | Excel Worksheet Functions | |||
| Some function problems | Excel Worksheet Functions | |||
| Function problems | New Users to Excel | |||
Threaded Mode
