G.P.A =IF(D10>=80,"4",IF(AND(D10<80,D10>=75),"3.75",IF(AND(D10<75,D10>=70),"3.50",IF(AND(D10<70,D10>=65),"3.25",IF(AND(D10<65,D10>=60),"3.00",IF(AND(D10<60,D10>=55),"2.75",IF(AND(D10<55,D10>=50),"2.50","0.00")))))))
Grade
=IF(D10>=80,"A+",IF(AND(D10<80,D10>=75),"A",IF(AND(D10<75,D10>=70),"A-",IF(AND(D10<70,D10>=65),"B+",IF(AND(D10<65,D10>=60),"B",IF(AND(D10<60,D10>=55),"B-",IF(AND(D10<55,D10>=50),"C+","F")))))))
Total Point
=SUM(E10+E11+E12+E13+E14+E15+E16+E17+E18+E19+E20+E21+E22+E23+E24+E25+E26+E27+E28+E29+E30+E31+E32+E33+E34+E35+E40+E41+E42+E43+E44+E45+E46+E47+E48+E54+E55+E56+E57+E58)/COUNT(D10:D58)
Grade
=IF(D10>=80,"A+",IF(AND(D10<80,D10>=75),"A",IF(AND(D10<75,D10>=70),"A-",IF(AND(D10<70,D10>=65),"B+",IF(AND(D10<65,D10>=60),"B",IF(AND(D10<60,D10>=55),"B-",IF(AND(D10<55,D10>=50),"C+","F")))))))