Set up a table and use VLOOKUP. For example,

A B
1 0 F
2 60 D
3 70 C
4 80 B
5 90 A
6
7
8
9
10 85 =VLOOKUP(A10,A1:B5,2,TRUE)

will return a B.



Of course, modify your table to include A-, B+, B-, etc


"downrightt" wrote:

I'm a teacher and trying to create a gradebook where it will assign letter
grades based on the numerical score. Because of all the possibilities, (A,
A-, B+, B, B-, C+, C, C-, D+, D, D-, F), I can't do it all in one cell
because it's too many embedded formulas for Excel to handle. I tried
splitting it up into two separate cells, but I can't figure it out.

Here are the formulas I'm using:

=IF(E7=$B$91,"A",IF(E7=$B$92,"A-",IF(E7=$B$93,"B+",IF(E7=$B$94,"B",IF(E7=$B$95, "B-",IF(E7=$B$96,IF(E7=$B$97,"C+",I7)))))))

And then, cell I7 is:
=IF(E7=$B$96,"C+",IF(E7=$B$97,"C",IF(E7=$B$98," C-",IF(E7=$B$99,"D+",IF(E7=$B$100,"D",IF(E7=$B$10 1,"D-",IF(E7=$B$102,"F","ERROR")))))))

Cell E7 is the numerical score I'm trying to convert, and cells B91 to B102
are the grading cutoffs (for example, an A is a 94 or higher), which I would
like to leave as references so that I can change it around later if I want.

Whenever the grade is below a C+, the cell's output is just "FALSE" instead
of it being refered to the second cell's forumla. Help! What am I doing wrong?