Lookup table

[Rhonda]

How to I create a lookup table (in the worksheet) and use the =lookup
function for a letter grade based on the quiz average with these rules:

An average below 60, the grade is a F.
An average of 60 or more but below 65, the grade is a D.
An average of 65 or more but below 70, the grade is a D+
An average of 70 or more but below 75, the grade is a C.

Thanks in advance!

Rhonda

 

[JE McGimpsey]

How to I create a lookup table (in the worksheet) and use the =lookup
function for a letter grade based on the quiz average with these rules:

An average below 60, the grade is a F.
An average of 60 or more but below 65, the grade is a D.
An average of 65 or more but below 70, the grade is a D+
An average of 70 or more but below 75, the grade is a C.

One way:

J K
1 Score Grade
2 0 F
3 60 D
4 65 D+
5 70 C
6 75 etc

If the quiz average is in A1:

=VLOOKUP(A1,$J:$K,2,TRUE)

 

[Rhonda]

Thank you JE but unfortunately I did not have enough info from you to make
this work. I posted another with add'l information that might help someone
help me, smile. Thanks anyway!