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

On Jun 30, 10:13*pm, GoBow777
wrote:
Hello:

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

Matt

--
GoBow777