Forum Discussion

ndimbo's avatar
ndimbo
Copper Contributor
Jun 21, 2021

Computing Grade Point Average (G.P.A)

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

2 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jun 21, 2021

    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.

Resources