# Exceeding limit on nested IF Statements

Posted by A on January 04, 2002 1:43 PM

Hi,
I'm trying to use nested "If" statements, to input table (tax tables!!!) data.
However, I've reached the maximum amount of "nesting" available. Any suggestions?

Posted by Jacob on January 04, 2002 1:51 PM

Hi

The limit is 7 right, anyways do you have to use Ifs first off? maybe you can use Vlookup instead. If you have to use Ifs then lets say in A1 you have 7 Ifs with the final false value being FALSE. and in B1 you have another 7 Ifs. Then In c1 you can put = if(A1=FALSE,B1,A1) and this would give you 14 Ifs. If these dont work post you formulas and I will try to be of further assistance. You may also be able to use a CSE array formula depending on what you are trying to do.

HTH

Jacob

Posted by Mike on January 06, 2002 3:52 PM

If don't usually need to nest that many IF statements. One way could be to use a counter:

mycounter=0
If a=1 then mycounter=mycounter+1
If b=1 then mycounter=mycounter+1
If c=1 then mycounter=mycounter+1
If d=1 then mycounter=mycounter+1
If e=1 then mycounter=mycounter+1
If f=1 then mycounter=mycounter+1
if mycounter=6 then DoIt

There are several other alternatives...Mike