Logic Error - ???Too long of a string???

  • Thread starter Thread starter Tracy Sanders
  • Start date Start date
T

Tracy Sanders

I have been working with an Excel formula and seem to be
having a problem. The first formula displayed below works
fine, but when I add any extra sub logic statement
demonstrated in the second formula below, I get an error.
It does not matter if it is one extra or the full string
needed. Can anyone tell me what I am doing wrong or is
Excel limited to only eight sub logic statements? I need
11 for what I am doing. Thank you in advance for any help.


=IF(D16>23.99,".07",IF(D16>18.49,".065",IF
(D16>17.99,".06",IF(D16>17.49,".055",IF(D16>16.99,".05",IF
(D16>16.49,".045",IF(D16>15.99,".04",IF
(D16>15.49,".035","F"))))))))


=IF(D16>23.99,".07",IF(D16>18.49,".065",IF
(D16>17.99,".06",IF(D16>17.49,".055",IF(D16>16.99,".05",IF
(D16>16.49,".045",IF(D16>15.99,".04",IF(D16>15.49,".035",IF
(D16>14.99,".03",IF(D16>14.49,".025",IF(D16>13.99,".02",IF
(D16>1,".00","F"))))))))))))
 
A lookup table should work for what you want. the nesting level for if
statements is 7.
 
Back
Top