View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] luckycharm1668@yahoo.com is offline
external usenet poster
 
Posts: 2
Default 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"))))