View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Convert GPA to Letter Grade

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.