vlookup help

jack-n-jill

New Member
Joined
Dec 11, 2005
Messages
7
I have a gradebook that I am setting up. Here's my grading scale:
>90 = A
80-89.99 = B
70-79.99 = C
60-69.99 = D
<60 = F

All of my averages are in column D and I want the letter grade to display in E. Thank you!!
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
jack-n-jill said:
I have a gradebook that I am setting up. Here's my grading scale:
>90 = A
80-89.99 = B
70-79.99 = C
60-69.99 = D
<60 = F

All of my averages are in column D and I want the letter grade to display in E. Thank you!!
Hi jack-n-jill:

Welcome to MrExcel Board!

You can use the VLOOKUP function ... as in cell E2 ...

=VLOOKUP(D2,{0,"F";60,"D";70,"C";80,"B";90,"A"},2)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,032
Messages
5,569,764
Members
412,291
Latest member
marypolitan
Top