Displaying a letter based on a percent Total

  • Thread starter Thread starter Rusty
  • Start date Start date
R

Rusty

Is there an easy way to make one cell display a certain
letter depending on a percent total in another cell? This
would be used to track my grade in a class. If it helps
here are the parameters. A = 100% -90 %
B = 89% - 80%
C = 70% - 79%
D = 69% - 60%
F = 59% - 0%
Thank you for your time.
Rusty
 
=VLOOKUP(A2,{0,"F";0.6,"D";0.7,"C";0.8,"B";0.9,"A"},2,1)

where A2 houses a percent total the formula converts to a letter grade.
 
Back
Top