IF Function

  • Thread starter Thread starter tw
  • Start date Start date
T

tw

Is there any way to nest more than functions in an IF
statment.

Example: 90-100 = A etc. can be written as =IF
(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF
(A2>59,"D","F")))). I would like to break the grades down
farther to A+, A, A-, but this requires more than seven IF
statements.
 
Is there any way to nest more than functions in an IF
statment.

Example: 90-100 = A etc. can be written as =IF
(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF
(A2>59,"D","F")))). I would like to break the grades down
farther to A+, A, A-, but this requires more than seven IF
statements.
Click to expand...

There is no way to next more than 7 functions. However, there are other
methods to do your grading.

For example, set up a table in I1:J12 showing the average grade and
corresponding Letter grades:

0 E
60 D-
65 D
70 C-
73 C
77 C+
80 B-
83 B
87 B+
90 A-
93 A
97 A+

Then use this formula (assuming the numeric grade is in A1):

=VLOOKUP(A1,I1:J12,2)


--ron
 
Back
Top