Hi Ruth,

Excel 2003 and earlier allows 7 levels of nesting. Excel 2007 allows 64
levels.

You can beat the 2003 limit by 1. Employing range names for portions of the
formulas, 2. Concatenation formula components, 3. Creating the formulas in
Lotus 1-2-3 or Quattro Pro and then import the file.

In my experience deep nesting is often the result of using an inefficient
approach to solving a problem - for example using a nested IF when one
should use a VLOOKUP.

Without seeing an example of your formula we will be limited on how we can
help.

Cheers,
Shane Devenshire
Microsoft Excel MVP

"Ruth" wrote in message
...
I have a worksheet that is making me crazy. Basically its a sales order
form
with drop down menus for each set of items based on category. I want the
MSRP
field to autofill with the prices when an item is selected and for this I
am
using the "if" with nesting. But it only allows me to nest 8 and I need
14.

Any suggestions on other functions I can use to accomplish this?