Problem using IF function for a gradebook

D

downrightt

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$101,"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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP Help 1
Double Metal Jacketed Gasket 0
using error type and if statement to return a value. 6
Hiding error values in cells 1
Function or Sub to help with text string 5
Changing GPA to Ltr Grade 8
How to concatenate cells that meets a specific criteria in threecolumns 6
How do I set up a conditional cell from a drop down list in Excel 3

Top