EXCEL FORMULA
0 minute read
EXCEL FORMULA
GRADE FROMULA:-
=IF(AND(H22>=20,H22<=40), "GRADE D",
IF(AND(H22>=40,H22<=60), "GRADE C",
IF(AND(H22>=60,H22<=80), "GRADE B",
IF(AND(H22>=80,H22<=100), "GRADE A"))))
"Grade Percentage as your wish"
PASS OR FAIL FORMULA:-
=IF(H22>=60,"PASS","FAIL")
RANK:-
=RANK(G22,$G$22:$G$28,)
press F4 and drag down to same value
Post a Comment