Forum Discussion
JackTradeOne
Mar 16, 2021Copper Contributor
Default values for LAMBDA parameters?
Is it possible to somehow include default values for LAMBDA functions with multiple parameters? For example, if my function is =LAMBDA(
height,
width,
height * width
); I would like to be able hav...
- Mar 16, 2021
If only as
=LAMBDA(height,width, IF(height, height,2)* width )(,4)
Lambda allows optional parameters if you have more than one of them. Missed parameters are returned as zero.
SergeiBaklan
Mar 16, 2021Diamond Contributor
If only as
=LAMBDA(height,width,
IF(height, height,2)* width
)(,4)
Lambda allows optional parameters if you have more than one of them. Missed parameters are returned as zero.