Worksheet IF Functions

A

AlvinAlvin

How do I create a function that will give letter grades for students within
a certain range. For example, John Doe has 89.6 and my grading scale is 90
and above A, 85-89 is an A-, 80-84 is a B+.

The percentages that have been calculated are in cell J5 and I would like
the answers in K5.

Thanks in advance
 
B

Bob Phillips

=LOOKUP(J5,{0,"F";0.4,"E-";0.45,"E";0.5,"D-";0.55,"D";0.6,"C-";0.65,"C";0.7,
"B-";0.75,"B";0.8,"B+";0.85,"A-";0.9,"A"})

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

bpeltzer

Create a table that shows your ranges and use a vlookup to make the assignment.
Ex: in AA1:AA4 enter the breakpoints: 0,80,85,90 and in AB1:AB4 the
corresponding grades: F,B+,A-,A (of course you'll complete the entire table).
Then in k5: =vlookup(j5,$AA1:$AB4,2,true) (chage the ending cell $AB$4 to
point to the end of your completed table)
--Bruce
 
Top