=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)


"AlvinAlvin" wrote in message
lkaboutsoftware.com...
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