Displaying a letter based on a percent Total

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
 
A

Aladin Akyurek

=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.
 
Top