Hi

There are techniques to get around the 7 level nesting limit in Excel,
but you would probably be better served by having a lookup table.

Post some more details about what you are trying to achieve, and someone
will be able to help you.
--
Regards

Roger Govier


"if'd out" <if'd wrote in message
...
I'm using Excel and trying to test items in conditional "if"
statements for a
payroll worksheet with about 20 steps to test. Excel will only allow
7
nested "if's". Is there a way to override this limit or another way
to
accomplish what I need?