Thanks for the response Roger. I have about 20 steps in the salary schedule
which gives a different annual raise based on the step. As a simple
illustration, moving from step 0 to step 1 gives the employee a $100 per year
raise. From step 1 to step 2 gives a $200 raise, step 2 to step 3 a $300
raise, etc. to step 20. With all employees set up in an Excel spreadsheet, I
am wanting my formula to read the step level of each employee and increase
the pay of each employee by the appropriate amount according to the
employee's step for the next year's budget prepartation. A lookup table
might be more appropriate but I have never used one and don't know where to
start.

"Roger Govier" wrote:

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?