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.
Tie CHENG You can actually do it just like you wanted, you just have to type the result directly, this means that:
=LAMBDA(4)() does return 4, and if you attach a parameter to it, it returns #VALUE