how can I allot distinction, first class, fail class in excel using formulas an
pls help its a hurry
Answers
Answered by
0
FOR CLASS
=IF(AND(I3>=85,I3<=100),"DISTINCTION",IF(AND(I3>=35,I3<85),"FIRST CLASS","FAIL"))
=IF(AND(I3>=85,I3<=100),"DISTINCTION",IF(AND(I3>=35,I3<85),"FIRST CLASS","FAIL"))
Similar questions