nested if statements error

  • Thread starter Thread starter juhlott
  • Start date Start date
J

juhlott

I have 12 nested if statements and I constantly get an
error at the beginning of the ninth statement. It is not
255 characters so I am not sure what is wrong. Help!
 
You've gone beyond the maximum number of nests allowable with IF.

You might be able to rewrite it for VLOOKUP.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
There is a widely known (here anyway) limit of 7 nested if statements.
Sounds like you managed to squeeze another one through (though doubtful),
but 9 is really pushing it. Commonly when someone is trying to jam a bunch
of if statements together, there is another option like a lookup formula
perhaps, but for that you would need to describe the layout of your data,
what you are trying to do and what your expected result is.
 
Thanks
-----Original Message-----
You've gone beyond the maximum number of nests allowable with IF.

You might be able to rewrite it for VLOOKUP.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"






.
Click to expand...
 
I have 12 nested if statements and I constantly get an
error at the beginning of the ninth statement. It is not
255 characters so I am not sure what is wrong. Help!
Click to expand...

You have exceeded a limit of Excel. See "Specifications" in HELP.

Excel specifications and limits
Nested levels of functions 7

There is almost certain to be another way of solving your problem. Most likely
one of the lookup functions will do the job.




--ron
 
Back
Top