Nested IF statments

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Excel 2003
It is my understanding the you can only "Nest" 7 IF statements inside each
other.

I need 15

Any suggestions?

=if(d3>94,"A",if(d3>89,"A-",if(d3>84,"B+"......................................)))

You get the idea. I want to assign a letter grade base upon a cell value but
there are more the 7 different possible letter grades.

How would I do this.

Any help here will be appreciated.

Thanks in advance
dave
 
You can set up a table of your scores and the appropriate grade
somewhere in your sheet like this:

0 G
20 F
30 E-
40 E
45 D-
50 D
55 D+
60 C-
65 C
70 C+
75 B-
80 B
85 B+
90 A-
95 A

Suppose this occupies M1:N15. Then, with your scores in column A, you
can use this:

=VLOOKUP(A1,M$1:N$15,2)

and copy this down as required.

Hope this helps.

Pete
 
Dave said:
Excel 2003
It is my understanding the you can only "Nest" 7  IF statements inside each
other.

I need 15

Any suggestions?

=if(d3>94,"A",if(d3>89,"A-",if(d3>84,"B+".......................................)))
Click to expand...
....

LOOKUP, e.g.,

=LOOKUP(D3,{0;54;59;64;69;74;79;84;89;94},{"F";"D";"C-";"C";"C
+";"B-";"B";"B+";"A-";"A"})

Modify as needed.
 
Try something like this:

=LOOKUP(D3,{0,60,66,70,73,77,80,83,87,90,93,97;"F","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"})

Adjust to suit your parameters.
 
Back
Top