Nesting level limits
How come a formula can only contain up to seven levels of nested
functions.... I need more than this, maybe 10 upwards..., how can I get around this problem? It seems a ridiculous limit seeing as Excel is a programme driven by a computer which can cope with thousands and thousands of formulae and functions! |
Nesting level limits
|
Nesting level limits
Also, you could use a defined name for part of your function
Click insert/names/define, in the refers to box type the piece of your larger function you want represented by name. For example NamedFunction = IF(AND(Condition1, Condition2), VLookup(Arg1, Arg2, Arg3, Arg4), "") Then, I could replace the IF statement in my larger function with the name, NamedFunction and save 2 levels of nested function calls. "DJ Magic" wrote: How come a formula can only contain up to seven levels of nested functions.... I need more than this, maybe 10 upwards..., how can I get around this problem? It seems a ridiculous limit seeing as Excel is a programme driven by a computer which can cope with thousands and thousands of formulae and functions! |
All times are GMT +1. The time now is 08:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com