I believe the max level of nesting is 7. Alternatives: CHOOSE or VLOOKUP.

"Shannon" wrote:

Is there a limit to the number of logical IF-THEN statements you can use in
one cell? I'm trying to use 12 in one cell. If there is a limit, is there a
work around?