ISOMITTED function

S’applique à
Excel pour Microsoft 365 Excel pour Microsoft 365 pour Mac Excel 2024 Excel 2024 pour 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