060822 perform 1 function, stop perform different function, with no regard
to result of first
simply put, need to perform 2 different steps in a formula; if good example:
=(2+2),(3+3)

need to finish to see result 6, but having performed 2+2 first. thanks.

----- working on / does not work:
=HYPERLINK(("#"&CELL("address",OFFSET($A$70,-1,1)),"#"&CELL("address",OFFSET($A466,$X$2,1))),"1 ")

-----
details:
I have a formula that works "In-Document" for showing which direction to go
(up or down),

=HYPERLINK(IF(ROW($A$466)<(ROW($A14)-($X$2/2)),"#"&CELL("address",OFFSET($A$466,-1,1)),"#"&CELL("address",OFFSET($A$466,$X$2,1)))," 1")


but if hyperlink is in header I either need to:
- identify position of my screen (below freeze-pane); not sure if
possible, or:
- perform 2 steps in one formula, (1 move to top of document, then 2 move
down to desired position).

need to combine the 2nd 2 items:
=HYPERLINK("#"&CELL("address",OFFSET($A466,-1,1)),"1") for up

=HYPERLINK("#"&CELL("address",OFFSET($A$70,-1,1)),"1") for top of
document
=HYPERLINK("#"&CELL("address",OFFSET($A466,$X$2,1) ),"1") for down


$X$2 is fixed cell / utility for size of screen in rows.
=48-CELL("row",$A$17) any # of rows-fixed point / size of freeze
pane=move x rows down.