Isomitted
Checks whether the value in a LAMBDA is missing and returns TRUE or FALSE.
Syntax
=ISOMITTED(argument)
The ISOMITTED function syntax has the following arguments:
argument The value you want to test, such as a LAMBDA parameter.
Examples
Example 1: Check for a missing parameter and return a friendly string
Copy the following formula into cell B1.
=LAMBDA(x,y, IF(ISOMITTED(y),”Missing second argument”,x+y))(1,)
