Forum Discussion
Minimum 64 levels of nesting are exceeded in Excel file
I need any suggestion about how can I overcome this problem?
That depends on the formula. Nested IF formulas can often be replaced by array lookups. Modern Excel (365) also provides LET which allows formulas to be restructured.
As a comment, in question was nothing about IF().
In general Excel has 64 as max limit for nested number of functions. Any functions, just IF() is most common case.
There are alternatives, as for everything in Excel. Which one depends on concrete situation.
- True. It is not a limit I normally hit so I simply took a guess to get the ball rolling