combine if(and statement
 

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"))))

combine if(and statement
 

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(w1925%,"More than 25%",if(w190,"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.

"
m wrote in message
...
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"))))

combine if(and statement
 

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


" 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"))))

combine if(and statement
 

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"))))

combine if(and statement
 

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"))))