Trying to see how to make separations in formula / find way to "result" use
of operators for an "IF", i.e.:

not working
=IF((CP9)IF($AK$2="u",,<)IF(CP9<CQ9,CQ9,CR9),"U" ,"-")

would be trying to get: CP9CQ9
will cut size of formula in half... thanks

nastech wrote:
Trying to see how to make separations in formula / find way to
"result" use of operators for an "IF", i.e.:

not working
=IF((CP9)IF($AK$2="u",,<)IF(CP9<CQ9,CQ9,CR9),"U" ,"-")

would be trying to get: CP9CQ9
will cut size of formula in half... thanks


I don't know if I well understand, but try this:

=IF($AK$2="u",CP9IF(CP9<CQ9,CQ9,CR9),CP9<IF(CP9< CQ9,CQ9,CR9))


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

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",CP9IF(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<CQ9,CQ9,CR9),IF($AK$2="u","U",IF($ AK$2="d","-","D"))))

= 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)



"Franz Verga" wrote:

nastech wrote:
Trying to see how to make separations in formula / find way to
"result" use of operators for an "IF", i.e.:

not working
=IF((CP9)IF($AK$2="u",,<)IF(CP9<CQ9,CQ9,CR9),"U" ,"-")

would be trying to get: CP9CQ9
will cut size of formula in half... thanks


I don't know if I well understand, but try this:

=IF($AK$2="u",CP9IF(CP9<CQ9,CQ9,CR9),CP9<IF(CP9< CQ9,CQ9,CR9))


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

oops, missed a "-" dash, in this formula:

=IF(OR(S9=".",CP9={"",0},CQ9={"","n/a"}),"",
IF(CP9=IF(CP9<CQ9,CQ9,CR9),IF($AK$2="u","U",IF($ AK$2="d","-","D")),"-"))

"Franz Verga" wrote:

nastech wrote:
Trying to see how to make separations in formula / find way to
"result" use of operators for an "IF", i.e.:

not working
=IF((CP9)IF($AK$2="u",,<)IF(CP9<CQ9,CQ9,CR9),"U" ,"-")

would be trying to get: CP9CQ9
will cut size of formula in half... thanks


I don't know if I well understand, but try this:

=IF($AK$2="u",CP9IF(CP9<CQ9,CQ9,CR9),CP9<IF(CP9< CQ9,CQ9,CR9))


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy