Convert GPA to Letter Grade

[Cindy]

I have a formula that is already matching my score to my GPA, this is being
pulled from the formula below:

formula is: =SUMPRODUCT(--($AR$2:$AR$37=D3),$AS$2:$AS$37)

lookup table sample is:
Score.........GPA........Grade..
100.......|.....4.......|.....A......
95.........|.....3.5....|.....A-....
90.........|......3......|......B....

NOW: I need the above formula to refer to the letter grade (A), (B), (C), etc.

 

[Pete_UK]

Do you mean you want to obtain the grade letter from the score? Please
explain in more detail what you want to do.

Pete

 

[Rick Rothstein]

To follow up on Pete's question...

What GPA score does 96, 97.5 and 99 get?

Does your table Scores continue to decline by 5's (to 60 for a 0) while your
GPA declines by 0.5's?

--
Rick (MVP - Excel)


Do you mean you want to obtain the grade letter from the score? Please
explain in more detail what you want to do.

Pete

 

[Cindy]

Score: Column AR from Row 2 thru 37 is 100 thru 65 (AR2=100, AR3=99, AR4=98
......etc).

GPA: Column AS from Row 2 thru 37 is 4 thru 0 (AS2 thru AS5 = 4, AS6 &
AS7=3.7, AS8 & AS9=3.5, AS10 thru AS12=3, AS13 thru AS15=2.7, AS16 thru
AS18=2.5, AS19 thru AS21=2, AS22 thru AS24=1.7 .......etc)

Letter Grade: Column AT from Row 2 thru 37 is A thru F (AT2 thru AT5=A, AT6
& AT7=A-, AT8 & AT9=B+, AT10 thru AT12=B, AT13 thru AT15=B-, AT16 thru
AT18=C+ ......etc)

The formula I mentioned transfers the Score (Column AR) to a GPA (Column AS)
......Now I'm needing to transfer the Score to Letter Grade (Column AT) and to
put the result in Column AP.

Please write back.....
Thanks,
Cindy