Why ISOMITTED does not work as expected?

[yushang]

Hi guys,

Take a look at the following figure, the formula in A1 is

=LAMBDA(x,ISOMITTED(x))()

What I expected is that A1=TRUE. Many thanks!

[#2 · Accepted solution]

@yushang 

TRUE is returned by

=LAMBDA([x], ISOMITTED(x) )()

[#3]

@Sergei Baklan Thanks, it works. I've never heard of this syntax, could you please tell me where to find the document about it? Thanks again!

[#4]

@yushang 

Sorry, I'm not sure about the documentation, please try to google.

Parameter(s) in bracket means optional one which could be omitted. Thus you may check for such optional parameters if they are omitted or not. And if omitted assign default value or do something you wish.

If parameter is not optional it can't be omitted and shall be passed to function. With ISOMITTED() you may check optional parameters. As an example

=LAMBDA(x, [y], LET( z, IF( ISOMITTED(y), 10, y), x+z) )(5)