Forum Discussion
Solved
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...
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.
JackTradeOne you can use the function =ISOMITTED() to change your lambda according to this need.