3 ms·
(1) is explicitly spelled out: > If you create a LAMBDA function in a cell without also calling it from within the cell, Excel returns a #CALC! error. For (2)
by int_19h 6y ago
(1) is explicitly spelled out:
> If you create a LAMBDA function in a cell without also calling it from within the cell, Excel returns a #CALC! error.
For (2), I think what they're saying is that if you need to test the function with different arguments, for example, it may be more convenient to reference the cell with the lambda.