ISOMITTED

This function is used to check whether the value in a LAMBDA is missing and returns TRUE or FALSE.

Syntax

ISOMITTED(argument)

Arguments

[Required] The value you want to test, such as a LAMBDA parameter.

Examples

LAMBDA(x,y, IF(ISOMITTED(y),"Missing second argument",x+y))(1,)