ISOMITTED function

Category: Information
Introduced: Excel 2024

Summary

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.

Example

=LAMBDA(x,y, IF(ISOMITTED(y),"Missing second argument",x+y))(1,)

Microsoft Support Page

https://support.microsoft.com/en-us/office/isomitted-function-831d6fbc-0f07-40c4-9c5b-9c73fd1d60c1

Back to Functions