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!

On Tue, 14 Mar 2006 18:38:28 -0800, DJ Magic <DJ
Magic@discussions.microsoft.com> wrote:

>How come a formula can only contain up to seven levels of nested
>functions....

You'd have to ask the programmers who designed the formula parser for an
answer.


>I need more than this, maybe 10 upwards..., how can I get
>around this problem?

You could wait for Excel 12; use a different program that could nest more
levels (e.g. Open Office); write your own program; post the details of your
problem here so as to obtain a solution within the design parameters of Excel,
etc.


--ron

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