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