4 ms·
Huh, are you sure? I don’t think you can (currently) define a lambda in a cell without also calling it in that cell (which means the cell now evaluates to the f
by ripley12 6y ago
Huh, are you sure? I don’t think you can (currently) define a lambda in a cell without also calling it in that cell (which means the cell now evaluates to the function’s return value, not a function). The LAMBDA docs:
“If you create a LAMBDA function in a cell without also calling it from within the cell, Excel returns a #CALC! error.”
https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67?ui=en-US&rs=en-CA&ad=CA https://support.microsoft.com/en-us/office/lambda-function-b...
- int_19h 6y agoIt will show #CALC! for that cell because, well, it has to show something for the result of the formula - but the formula didn't evaluate to a "displayable" value.
- ripley12 6y agoYeah that wasn't the best example on my part. But I have tried it and confirmed that calling lambdas defined in another grid cell doesn't work. Specifically: 1) Put =LAMBDA(x, x+1) in A1 2) Try calling =A1(1) from any other cell - it will return #REF! I'm on the Office Insiders beta track and LAMBDA does work otherwise.