combine if(and statement

[luckycharm1668]

Hi,

I would like to combine the following into one formula.
Could you please help? Getting frustrated ...

=IF(AND(W19>=0%,W19<>"",W19<25%),"On Plan
OVER",IF(AND(W19>=-25%,W19<>"",W19<0%),"On Plan Under",""))
cobine with
=IF(W19="","",IF(W19>0.25,"OVER", IF(W19>-0.25,"ON
PLAN",IF(W19=0,"n/a","UNDER"))))

 

[Fred Smith]

What result do you want? Both statements check for virtually the same thing
(eg, 25% and .25 are the same number). Do you want something like:

=if(w19="","",if(w19=0,"n/a",if(w19>25%,"More than 25%",if(w19>0,"On Plan
Over",if(w19>-25%,"On Plan Under","Less than -25%")))))

If not, tell us what result you want for each range of w19.

Regards,
Fred.

"(e-mail address removed)"

 

[Elkar]

You could try using a LOOKUP function:

=IF(W19="","",LOOKUP(W19,{-1,-0.25,0,0.01,0.25},{"UNDER","On Plan
Under","N/A","On Plan Over","OVER"}))

HTH
Elkar

 

[Shane Devenshire]

These two if function give different results for the same criteria, You need
to rework you question.

For example:
IF(W19>-0.25,"ON PLAN"
and
W19>=-25%,W19<>"",W19<0%),"On Plan Under"
overlap each other??

Also you are check for W19="" and W19<>"" this is redundent.

(maybe) You are also missing a value for W19=.25 ?

Further W18>=0 and W19=0 are in conflict.


Why make a nice little table
<-.25 x

=-.25 to <0 y 0 to <.25 z
.25 w

 

[luckycharm1668]

Hi Shane,

I finally figured it out.
Thanks everyone for your help.
Have a wonderful day!

Thanks,
Margie