Microsoft Excel 2000 Question?

I am looking to see if it is possible in Microsoft Excel 2000 to increase the maximum number of arguments in a nested "IF" function from 8 to 31. If so, then how do I increase the maximum number?

Microsoft Excel 2000 Question?viruses

You can't increase the maximum number of nested IFs, but there may be other ways to accomplish the same thing.

If you provide more details about what you would like to do we can be more specific, but here a couple of options that may help.

1) if the values you're checking are 1,2,3, etc. then the CHOOSE function gets you close, since it allows up to 29 values to be checked. So you can have two formulas (value being checked in A1):

=IF(A1%26lt;=29, CHOOSE(A1, firstaction, secondaction, etc. to 29th action), CHOOSE(A1-29, 30th action, 31st action))

2) Otherwise, the LOOKUP functions often work -- in most cases, VLOOKUP in particular. If you're not familiar with VLOOKUP, it searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. HLOOKUP is similar but looks across the top row of a table. See Excel help, or this link for more info:

http://www.officearticles.com/excel/vloo...

If you need more info, add more details or e-mail.

Cheers.

.

Microsoft Excel 2000 Question?antispam

There is no way to increase the number of allowed nested arguments that I am aware of.

Having said that, a way you could work around this is to break it up across multiple cells. So in one cell you evaluate 8 nested if's that end up returning either true or false. Then in the next cell you use the output of the previous cell to trigger the next set of nested if's.