Nested IF

[Frank Kabel]

Hi use a lookup table for this. e.g. on a separate sheet
called 'lookup'
A B
1 69.49 F
2 74.49 C
...
Now use a formula like
=VLOOKUP(C4,'lookup'A1:B10,2)

-----Original Message-----
I have a requirement that I am using a nested if

statement in order to return the desired result, however,
it is to deep, can someone give me ideas how to change
this so that it will work?

IF(C4>98.49,"A+",IF(C4>95.49,"A",IF(C4>91.49,"A-",IF (C4>87.49,"B+",IF(C4>83.49,"B",IF(C4>79.49,"B-",IF
(C4>74.49,"C+",IF(C4>69.49,"C","F",IF(OR
(C4>69.49,E4>69.49,"B+","F"))))))))))

This assigns the applicable grade level and the final is

if they fail the first exam they get a rewrite and if they
pass it the maximum they can receive is a B+.