Nested Function Calls

H

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).
 
R

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).
Click to expand...


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




--ron
 
H

Harlan Grove

Ron Rosenfeld said:
Interesting. Although I still can't ENTER a formula (in Excel) with
more than seven nesting levels.
Click to expand...

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.
 
R

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.
Click to expand...

Agreed.


--ron
 
Top