Formula to compute letter grade based on percentage grade

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.
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top