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​​​​​​​

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.