Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac

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

ISMISSING function example

See Also

LAMBDA function

MAP function

REDUCE function

SCAN function

MAKEARRAY function

BYCOL function

BYROW function