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 first 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.