Lambda Example: Generate Fibonacci series

Viz et al

Thanks for this discussion.  It has been useful in taking me from the point where I didn't know there was a limit on the level of recursion achievable to actually acquiring some understanding of the factors involved.

tboulden 

I am pleased the exchange of workbooks has delivered an idea that may be useful to you.  Thanks for introducing me to the Collatz sequence, it proved interesting.  I modified my Fibonacci workbook to implement the sequence which served to reinforce what I think of as 'the anatomy of a recursive Lambda function.  I have yet to achieve a consistent development and testing strategy though.

I modified the Macro that uploads Lambda formulas from the worksheet to allow the option of cancelling out and so leaving the Lambda definition unaltered (more accurately, to copy the formula before deleting it, so that it can be reinstated if the changes cause the formula to fail.  I have also included a small Lambda function to collect the scalar values returned, last first, from the recursion stack as an array.  

I have yet to decide whether Lambdas are a novelty, (to be brought out to show off or at times of extreme need) or whether they provide the basic building blocks of future Excel solutions.