Hi Jim,

Your profile says you're using Excel 2003, which is what my response applied to. The help you're referring to comes from a later version. And, even if you're working with Excel 2007 or later, if the workbook is in the older 97-2003 format, that still won't support more than 8 nested IFs. In any event, there are better ways than using a plethora of nested IFs (which can become very difficult to debug & modify).

If you can post a copy of the workbook with representative data, I or someone else here might be able to suggest a better approach/solution.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]