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

1. ## 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  Register To Reply

2. ## Re: 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: 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.

Ciao

Franz Verga from Italy  Register To Reply

3. ## Re: 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
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.

- 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
>
>
>  Register To Reply

4. ## Re: 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: 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
>
>
>  Register To Reply

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1