Computing Grade Point Average (G.P.A)

[ndimbo]

Please can you help me procedures and formula for calculating GPA when you prepare students results

[#2]

@ndimbo 

There are many different grading systems in use around the world - see Grading systems by country, so you will have to tell us which system you use,

[#3]

@ndimbo 

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.