Forum Discussion
Solved
Is it possible to define a function with no argument by LAMBDA?
In Excel, we have functions with no argument such as PI(), RAND(), NOW(). However, it seems that we cannot define such a function by LAMBDA. I tried in a cell `=LAMBDA(,4)()` (and expected 4 ...
Yes, it seems to be possible. e.g. given a named reference 'x'
=LAMBDA(x+1)()
returns x+1.
=LAMBDA(x+1)
returns a #CALC! error.
If you name the Lambda function INCx then the same results are obtained for
=INCx()
and
=INCx
respectively. I think I have read of such functions being referred to as 'thunks' and would be used to pass a resource-intensive operation as a parameter without evaluating it before the result is needed.
The possibility of defining and testing for an optional parameter is being rolled out.
With latest lambdas edition your sample could be like
=LAMBDA([x],4)()which returns 4. You have no arguments but have optional parameter.
Good to know... Thank you...