Notifications
Clear all
General Excel Questions & Answers
3
Posts
3
Users
0
Reactions
118
Views
Topic starter
How many functions can I insert in ?
Attached is a screenshot with a complex function that I built and now I get an error message
The formula you specified can not be entered because it uses the most nesting levels allowed.
What is the solution?
Thank you!
Posted : 07/03/2018 4:14 am
Hi lea
I am using Excel 2010 and I believe the maximum level for nested IF() is 7 (Excel 2010).
Maybe you could try breaking your formula into 2 or more parts. It will all depend on the complexity of the formula.
Sunny
Posted : 07/03/2018 7:05 pm
Hello,
There is a good Excel Nested IF functions explained from Mynda about nested IFs, check it out.
Br,
Anders Sehlstedt
Posted : 07/03/2018 7:24 pm
