Is it possible to apply IF's to "operator" result..
 

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

Is it possible to apply IF's to "operator" result..
 

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

Is it possible to apply IF's to "operator" result..
 

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

Is it possible to apply IF's to "operator" result..
 

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