Question

how can I allot distinction, first class, fail class in excel using formulas an
pls help its a hurry

Answer 1

FOR CLASS

=IF(AND(I3>=85,I3<=100),"DISTINCTION",IF(AND(I3>=35,I3<85),"FIRST CLASS","FAIL"))