S
S.Hinkle
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.
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.