Hi, thanks for your reply, you have the right idea.
I have some funny formula's, been can not do things before, but later found
the answer.
was trying to Just "TEST" for which operator to use, for: < or >
instead of typing out 2 "half's" of the same formula
bet there is a way to do that with some form of brackets, quotes.. something
=IF($AK$2="u","<",">" or [>],[<] {<},{>}
like I say, answer to that would cut formula's in half.
in your example, that is about what I had before. mine is double long for
use of U or D answers (up or down). I can cut that in half, (but still..)
e.g.:
=IF(OR(S9=".",CP9={"",0},CQ9={"","n/a"}),""
IF(AND($AK$2="u",CP9>IF(CP9<>CQ9,CQ9,CR9)),"U",IF(AND($AK$2="d",CP9<IF(CP9<>CQ9,CQ9,CR9)),"D","-")))
here's a trick I just rediscovered, used this before, should work:
=IF(OR(S9=".",CP9={"",0},CQ9={"","n/a"}),"",
IF(CP9>=IF(CP9 said:
= precludes a False condition, but gives a false "U", if number is same for both days.. no problem. Thanks.
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
----------- other formula was told I couldn't do: (new version works better)
Hyperlink to put "in-document" Title lines (takes to exact spot of header,
up or down, add or delete lines). This was a severe problem for doing work,
lines moving.
=HYPERLINK(IF(ROW($A$614)<(ROW($A614)-($W$1/2)),"#"&CELL("address",OFFSET($A$614,-1,1)),"#"&CELL("address",OFFSET($A$614,$W$1,1))),"A")
- row($a614 no dollar sign, is row this formula is in
- $w$1 is work around formula for amount of rows your screen shows
(/below freezepane), formula is: (48 any number, minus last row in freeze
pane=number rows you have showing).
=48-CELL("row",$A$19)
