+1(514) 937-9445 or Toll-free (Canada & US) +1 (888) 947-9445

How to Calculate CGPA?

kismail96

Star Member
Aug 15, 2012
144
2
125
Pakistan
Job Offer........
Pre-Assessed..
On Virtual University website, an excel sheet is availabble. They applied this formula
=ROUND((IF(E7>=80,4,IF(AND(E7<80,E7>=65),3+(E7-65)/15,IF(AND(E7<65,E7>=50),2+(E7-50)/15,IF(AND(E7<50,E7>=40),1+(E7-40)/10,0))))),2)
According to this formula, 70% means 3.33
Is it correct?