Grade Ponit [Mark theke] =IF(C5="AB","ABSENT",IFS(C5>=80,5,C5>=70,4,C5>=60,3,C5>=50,2,C5>=0,0)) Total Mark =IF(OR(C5="AB",E5="AB",G5="AB"),"ABSENT",IF(OR(C5<50,E5<50,G5<50),0,SUM(C5,E5,G5))) Average Grade Point [GPA] =IF(OR(C5="AB",E5="AB",G5="AB"),"ABSENT",IF(OR(C5<50,E5<50,G5<50),0,SUM(D5,F5,H5)/3)) Letter Grade [GPA theke] =IF(J5="ABSENT","ABSENT",IFS(J5=5,"A+",J5>=4,"A",J5>=3,"B",J5>=2,"C",J5>=0,"F")) Rank [Position] GPA theke =IF(J5="ABSENT","ABSENT",IF(J5=0,0,RANK(J5,$J$5:$J$9,0))) Commet [GPA Thele] =IF(J6="ABSENT","ABSENT",IF(J6=0,"FAIL","Pass")) Student Name thke GPA =VLOOKUP(C15,$B$3:$J$9,9,0)