multiple nested IF Statements

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

I am looking to create a grade sheet that assigns grades
of A, A-, B+, B-, B, C+, C, C-, D, F. As you can see
there are more than seven IF Statements that need to be
nested. My EXCEL Literature and Error Message say that
seven is the maximum number of IFs that an be
inserted/nested. True ?
How can I create this grade sheet that reads the
cumulative numerical grades of 40 students and assigns
their LETTER grades in terms of +, or - or plain letter
grade?
Help !! Grades are due SOON !
 
Jay,

Use a table and VLOOKUP.

Table would be in H1:J5 say and hold values
0 F
25 D
80 B+
85 A-
90 A

(skipped some in the example)

The values in the table are where the grade starts.

then just use

=VLOOKUP(81,H1:J5,2)

If the score is in say A1, just use

=VLOOKUP(A1,H1:J5)

Extend the table and reference to suit your number of grades, and add your
own start points.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top