ISOMITTED

ISOMITTED(argument)

Returns the boolean True or False depending whether the value in a LAMBDA is missing.

argument

The LAMBDA parameter you want to test.

REMARKS

* This function was added in Microsoft 365.
* This function uses the LAMBDA function.
* The parameter names must not contain any numbers.
* This function was released in July 2021.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=LAMBDA(p_one,p_two,IF(ISOMITTED(p_two),"Missing",p_one+p_two))(1,) = Missing

1 - How to check for a missing parameter in a LAMBDA function.