| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert GPA to Letter Grade
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grade Percentage into letter grade | Excel Discussion (Misc queries) | |||
| try to convert letter grades into GPA grade points | Excel Worksheet Functions | |||
| hOW CAN I CONVERT NUMERICAL POINTS INTO A LETTER GRADE(SCHOOL) | Excel Worksheet Functions | |||
| I am trying to set a letter grade for my students, HELP | Excel Worksheet Functions | |||
| X Y with Letter grade Labels | Charts and Charting in Excel | |||
Threaded Mode
