mardi 3 février 2015

I need to write an if statement in Excel based on 3 different cells condition

What I need is If cell A1="B", and B1>1, and C1<70%, then it will be "Exceptional", others will be note as "Normal". There have 3 type of possibility, I need put all into excel.


My Formula input in excel is show as per below "=IF(AND(G2="B",C2>1,I2<70%),"Exceptional",IF(AND(G2="C",C2>1,F2<=65%),"Exceptional",IF(AND(G2="D",C2>1,F2<=50%),"Exceptional",IF(AND(G2="E",C2>1,F2<=50%),"Exceptional","Correct"))))"


However it only apply for Situation 1 but not remaining.


Aucun commentaire:

Enregistrer un commentaire