Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to compute letter grade based on percentage grade
I am a student and I've made a worksheet to record my grades in a class.
Using the syllabus, I've created columns for points possible and points earned, and Excel calculates my total percentage correct. I want to write a formula that outputs a letter grade based on my percentage grade. Something like this: IF percentage is 90-100, THEN "A" IF percentage is 80-89, THEN "B" etc. for "C" "D" "F" Even better if it can create letter grades with a + or -. I only know how to write an IF/THEN formula that creates two outputs. Thank You. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to compute letter grade based on percentage grade
Try the below
Col A Col B 100% =LOOKUP(A1*100,{60,70,80,90},{"D","C","B","A"}) If this post helps click Yes --------------- Jacob Skaria "S.Hinkle" wrote: I am a student and I've made a worksheet to record my grades in a class. Using the syllabus, I've created columns for points possible and points earned, and Excel calculates my total percentage correct. I want to write a formula that outputs a letter grade based on my percentage grade. Something like this: IF percentage is 90-100, THEN "A" IF percentage is 80-89, THEN "B" etc. for "C" "D" "F" Even better if it can create letter grades with a + or -. I only know how to write an IF/THEN formula that creates two outputs. Thank You. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when doing a grade book how do you drop the lowest grade | Excel Worksheet Functions | |||
when doing a grade book how do you drop the lowest grade | Excel Worksheet Functions | |||
Grade Percentage into letter grade | Excel Discussion (Misc queries) | |||
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 |