Hyperlink function in an If function

[GoBow777]

Hello:

I'm using Excel 2003, and what I'm trying to do is use the HYPERLIN
function in an IF statement so that if the value is TRUE then th
HYPERLINK is active and if the value is FALSE then the HYPERLINK woul
be inactive. Does any one know of a way to make this work withou
getting the error message, "Cannot open the specified file.".

Mat

 

[Pete_UK]

I put this formula in B8 as a test:

=IF(A8="","",HYPERLINK("#A4","jump"))

If A8 is empty then B8 appears empty, and you can click on that cell
and stay there. But, if you put something in A8 then the word "jump"
appears in B8 and if you click on that cell now the cursor will jump
to A4. Is this the kind of thing you wanted?

Hope this helps.

Pete

 

[GoBow777]

Thanks Pete! That works just fine.

Matt

I put this formula in B8 as a test:

=IF(A8="","",HYPERLINK("#A4","jump"))

If A8 is empty then B8 appears empty, and you can click on that cell
and stay there. But, if you put something in A8 then the word "jump"
appears in B8 and if you click on that cell now the cursor will jump
to A4. Is this the kind of thing you wanted?

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Matt - thanks for feeding back.

Pete