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!
|