What's wrong with this formula please?

[taniab]

"Advanced" : Behaviours (J11) = 100% AND % above C grade (I11)= 100% AND Attendance (E11) = greater than or equal to 92%
"Good" : Behaviours >= 50% AND % above C grade => 60% AND Attendance = greater than or equal to 90%
"Conditional" : Behaviours <= 50% AND % above C grade <=60% AND Attendance <= to 92%
Else "Error"

When attendance is 50%, it is returning "FALSE"

What is wrong with my formula please?

=IF(AND(J11>=1,E11>0.92,I11>=1),"Advanced",IF(AND(J11>=0.5,E11>=0.9,I11>=0.6),"Good",IF(AND(J11<0.5,E11<0.9,I11<0.6),"Conditional,""error")))

 

[mrshl9898]

=IF(AND(J11>=1,E11>0.92,I11>=1),"Advanced",IF(AND(J11>=0.5,E11>=0.9,I11>=0.6),"Good",IF(AND(J11<0.5,E11<0.9,I11<0.6),"Conditional","error")))

 

[taniab]

That doesn't work. I think it's because "Good standing" needs to have BETWEEN formulas

 

[mrshl9898]

Well there was a keying error in the first formula which was causing the issue. Can you provide examples of what your expected results are?

 

[AhoyNC]

Maybe:

IF(AND(J11>=1,E11>0.92,I11>=1),"Advanced",IF(AND(J11>=0.5,E11>=0.9,I11>=0.6),"Good",IF(OR(J11<0.5,E11<0.9,I11<0.6),"Conditional","error")))