ExcelBanter - View Single Post

On Tue, 14 Mar 2006 18:38:28 -0800, DJ Magic <DJ
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