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

 

[mme58]

Hey,
This would be something like
=IF(A1>=90,"A",IF(A1>=80,"B",IF(A1>=70,"C",IF(A1>=60,"D","F"))))
Please note:
- You need to change the name of the cell to whatever the name of the cell is in your case (AR)
- This only gives A, B, C, D, E letters and does not give A+, A-, etc... however this is easy to add by only adding some more IF statements and fragmenting the range further.

Hope this helped.
Write back if you need more help on this issue.