Nested Function Calls

[Harlan Grove]

Finally got around to putting a copy of an .XLS file created using
StarOffice 5.2 that shows a formula in cell A1 with many more than 7 levels
of nested function calls. Just in case anyone thought the stated limit was
any firmer than the 1024 character per cell display limit.

ftp://members.aol.com/hrlngrv/so52test.xls

I also tried to create an array formula with more than 7 levels of nested
function calls, but couldn't (at least not in SO52, which is all I have on
this particular machine). However, since I'm 90% convinced that the formula
parser handles array formula evaluation in conjunction with the
recalculation portion of Excel, so the formula parser's limits on nested
function calls actually set a true limit on array formulas, this wasn't a
big surprise (though it was a disappointment).

 

[Ron Rosenfeld]

Finally got around to putting a copy of an .XLS file created using
StarOffice 5.2 that shows a formula in cell A1 with many more than 7 levels
of nested function calls. Just in case anyone thought the stated limit was
any firmer than the 1024 character per cell display limit.

ftp://members.aol.com/hrlngrv/so52test.xls

I also tried to create an array formula with more than 7 levels of nested
function calls, but couldn't (at least not in SO52, which is all I have on
this particular machine). However, since I'm 90% convinced that the formula
parser handles array formula evaluation in conjunction with the
recalculation portion of Excel, so the formula parser's limits on nested
function calls actually set a true limit on array formulas, this wasn't a
big surprise (though it was a disappointment).

Interesting. Although I still can't ENTER a formula (in Excel) with more than
seven nesting levels.




--ron

 

[Harlan Grove]

Interesting. Although I still can't ENTER a formula (in Excel) with
more than seven nesting levels.

Understood. However, inability to enter such formulas is obviously not due
to limitations on what Excel can recalculate once entered. Rather, it
appears to be solely a limitation of the formula parser.

 

[Ron Rosenfeld]

Understood. However, inability to enter such formulas is obviously not due
to limitations on what Excel can recalculate once entered. Rather, it
appears to be solely a limitation of the formula parser.

Agreed.


--ron