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.
tboulden
Mar 17, 2021Iron Contributor
Sergei's suggestion will serve you well for those specifications then, I was proffering the suggestion in case your use case might be more open-ended.
JackTradeOne
Mar 17, 2021Copper Contributor
Got it! Thanks again.