Nested IF Statements Linking Problem

You could use two colums, J & K

in J2
=IF(I2>84,"A+",IF(I2>79,"A",IF(I2>74,"A-",IF(I2>69,"B+",IF(I2>64,"B",IF(I2>59,"B-",IF(I2>54,"C+",IF(I2>49,"C",K2))))))))

in K2
=IF(i2>49,"",if(I2>39,"D","E"))

which will copy down, then hide column K

hth


note this formula was untested, just a copy of your formula.
---

Originally Posted by skratch

I've just run into a little problem while trying to setup a grade book for work, I just want to print out whether the students get an A+,A,A-,B+,B,etc

I discovered early on that I for some reason excel won't let you nest anymore than 7 if-statements in one function, being a beginner in excel, the only way I could think about getting round this was to use a named function to link two lots of nested if statements, it all worked fine with one cell but when I went to fill down, I realised that I was only making the references in the intial nested if statement fill down, the references in the named function are still only pointing to the intial cell and not filling down.

Does anyone know how to remedy this problem. I'm sorry if I havent made myself completely clear here's my code below if that helps, any other questions just let me know :-)

Grade Cell:
=IF(I2>84,"A+",IF(I2>79,"A",IF(I2>74,"A-",IF(I2>69,"B+",IF(I2>64,"B",IF(I2>59,"B-",IF(I2>54,"C+",IF(I2>49,"C",DtoE))))))))

DtoE Cell:
=IF(I2>39,"D","E")


Thanks!