ISOMITTED function

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,)

See Also

LAMBDA function

MAP function

REDUCE function

SCAN function

MAKEARRAY function

BYCOL function

BYROW function