Forum Discussion
Help Needed with Using Thunks with SCAN
- May 08, 2025
You were pretty much there
The changes I made were
- to remove the CHOOSE function to simplify the definition of arrays
- to avoid the (illegal) use of cell references as LET variables
- To simplify the evaluation of the result of the SCAN
The main issue was the fact that cell addresses are not valid as names within LET. I have also demonstrated the passing of functions as parameters and included a demonstration of the evaluation of arrays of thunks. Your formula using REDUCE offers the most effective approach if you only require values returned from the final step.
You were pretty much there
The changes I made were
- to remove the CHOOSE function to simplify the definition of arrays
- to avoid the (illegal) use of cell references as LET variables
- To simplify the evaluation of the result of the SCAN
The main issue was the fact that cell addresses are not valid as names within LET. I have also demonstrated the passing of functions as parameters and included a demonstration of the evaluation of arrays of thunks. Your formula using REDUCE offers the most effective approach if you only require values returned from the final step.