Formula is not working for ABSENT student in marksheet

Respected Sir,

I am trying with this formula to make a marksheet in excel.

=IF(AND(ISNUMBER(A2),ISNUMBER(B2),A2>=32,B2>=8),"F",IF(AND(A2=32,OR(B2="AA",B2<8)),"T",IF(AND(OR(A2<32,A2="AA"),AND(ISNUMBER(B2),B2>=8)),"I","")))

As per the formula, Theory paper passing marks is 32 & Practical's passing is 8.

If a student gets the marks as above mentioned then he got the Full Exemption in the subject as "F"
"T" exemption stands for if he gets the minimum 32 marks in Theory and less than 8 in Internal..

So as, "I" exemption stands for if he gets the minimum 8 marks in Practical and less than 32 in Theory..
But, if a students gets more than 32 marks in Theory and Absent (AA) in Practical, the the above formula is not working properly...

=if(and(isnumber(a2),isnumber(b2),a2>=32,b2>=8),"f",if(and(a2>=32,or(b2="aa",b2<8)),"t",if(and(or(a2<32,a2="aa"),and(isnumber(b2),b2>=8)),"i","")))

Originally Posted by PaulM100

=if(and(isnumber(a2),isnumber(b2),a2>=32,b2>=8),"f",if(and(a2>=32,or(b2="aa",b2<8)),"t",if(and(or(a2<32,a2="aa"),and(isnumber(b2),b2>=8)),"i","")))

Thanks Sir... But yet this formula is not working properly.. If a student having "AA" (Absent) in the both, i.e. Theory & Practical.. It's Showing result as "T"

This will work:
=IF(AND(ISNUMBER(A2),A2>=32,B2="AA"),"T",IF(AND(A2="AA",B2="AA"),"",IF(AND(ISNUMBER(A2),ISNUMBER(B2),A2>=32,B2>=8),"F",IF(AND(OR(A2="AA",A2<32),ISNUMBER(B2),B2>=8),"I",""))))

Originally Posted by PaulM100

This will work:
=IF(AND(ISNUMBER(A2),A2>=32,B2="AA"),"T",IF(AND(A2="AA",B2="AA"),"",IF(AND(ISNUMBER(A2),ISNUMBER(B2),A2>=32,B2>=8),"F",IF(AND(OR(A2="AA",A2<32),ISNUMBER(B2),B2>=8),"I",""))))

Thanks a Lot Sir... Now its working properly... This thread has been solved.. Thanx again..