>> I think Andy was talking about how Excel would support recursion, not
>> how a user would implement a recusive function. Currently Excel would
>> throw a "Circular reference" error.
>
> ...unless you have checked the "Iteration" box under
> Options->Calculation. It's possible to then write a recursive formula,

Yes. The paper specifically mentions this, and how it breaks the 
spreadsheet model by making each cell's value time-dependent.

(They referred to it as a "dangerous feature". I'm not sure I'd go that 
far, but...)

Usually you use this because you expect the values involved to converge 
to some kind of fixed-point after a few iterations. If that actually 
turns out to be true, then time-dependent behaviour isn't such a big deal.

Post a reply to this message