Forum Discussion
Computing Grade Point Average (G.P.A)
Please can you help me procedures and formula for calculating GPA when you prepare students results
Excel Formula for Grade
The logic that is defined in the formula is
If the percentage is more than 80, than the student falls in Grade A
=IF(H2>80%,”A”,IF(H2>70%,”B”,IF(H2>60%,”C”,”D”)))
If the percentage is more than 70, than the student falls in Grade B.
=IF(H2>80%,”A”,IF(H2>70%,”B”,IF(H2>60%,”C”,”D”)))
If the percentage is more than 60, than the student falls in Grade C.
=IF(H2>80%,”A”,IF(H2>70%,”B”,IF(H2>60%,”C”,”D”)))
At last, if the percentage is less than 60, than the student falls in Grade D.
=IF(H2>80%,”A”,IF(H2>70%,”B”,IF(H2>60%,”C”,”D”)))
Hope I could help you with this information.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.