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.

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

Pete

On Dec 11, 6:36*pm, Cindy wrote:
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.

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)


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

Pete

On Dec 11, 6:36 pm, Cindy wrote:
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.

Sco 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

"Rick Rothstein" wrote:

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)


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

Pete

On Dec 11, 6:36 pm, Cindy wrote:
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.