Hi

I just cant get my head around this - some of the cells only require if statements whereas some require if(and statements - what am I doing wrong here?

=if(A2=B2,"No Change",(if(A2>B2,"Value Decrease", if(A2<B2,"Value Increase", if(and(A2=0, B2>0.01,"New", if(and(A2>0.01,B2<0,"No Longer Applicable")))))

Thanks