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