Student result in excel

Students Ranking 1st, 2nd, 3rd - =RANK(A2,A$2:A$8)&MID("thstndrdth",MIN(9,2*RIGHT(RANK(A2,A$2:A$8))*(MOD(RANK(A2,A$2:A$8)-11,100)>2)+1),2)

0-10% nikalna

=COUNTIF(D9:D34,">=0")-COUNTIF(D9:D34,">2")

=SUM(AJ9,AL9,AN9,AG9)

Pass fail
=IF(AO9>=32,"PASS","FAIL")
Grade
=IF(AO9<32,"E",IF(AO9<50,"D",IF(AO9<75,"C",IF(AO9<90,"B",IF(AO9<100,"A")))))

=COUNTIFS(A1:A100,"<=10",B1:B100,"M",C1:C100,"BC",D1:D100,"G")