Hi Shane,

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

Thanks,
Margie

"Shane Devenshire" wrote:

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


" wrote:

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(W190.25,"OVER", IF(W19-0.25,"ON
PLAN",IF(W19=0,"n/a","UNDER"))))