MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Exceeding limit on nested IF Statements

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

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?
Thank you, in advance!

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


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.



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:

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