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: CP9>CQ9
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: CP9>CQ9
> will cut size of formula in half... thanks


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

=IF($AK$2="u",CP9>IF(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",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<>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: CP9>CQ9
> > will cut size of formula in half... thanks
>
>
> I don't know if I well understand, but try this:
>
> =IF($AK$2="u",CP9>IF(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: CP9>CQ9
> > will cut size of formula in half... thanks
>
>
> I don't know if I well understand, but try this:
>
> =IF($AK$2="u",CP9>IF(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
>
>
>