if a cell has a value greater than 0, then atomaticaly goto a seperate page for addit

F

Frankso

Dear Help forum,

I'm trying to set up a formula that will automatically move me t
another sheet if a value greater than 0 is entered in certin cells.

Thank you
Fran
 
D

Dave Peterson

A formula returns a value to the cell that holds it.

It can't move you.

But maybe you could use a =hyperlink() formula that would allow you to click the
link and go to the other location.

I put this formula in A3 that linked to a different sheet if A1 > 0 or linked to
itself (A3) if A1 was non-positive.

=HYPERLINK(IF(A1>0,"#"&CELL("address",'Sheet two'!C5),
"#"&CELL("address",A3)),"clickme")

(all one cell)
 
Top