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.
 

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