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 Excel 2024.
* The parameter names must not contain any numbers.
* This function was first released in July 2021.
* You can use the LAMBDA function to return the results of a formula added as a named range.
* You can use the AND function to return the boolean True or False depending on multiple conditions.
* You can use the IF function to return the value based on whether a condition is True or False.
* You can use the LET function to return the result of a formula that can use variables.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=LAMBDA(p_one, p_two, p_one+p_two)(1, 2) = 3
2	=LAMBDA(p_one, p_two, IF(ISOMITTED(p_one), "no one", p_one+p_two))(, 1) = no one
3	=LAMBDA(p_one, p_two, IF(ISOMITTED(p_two), "no two", p_one+p_two))(1, ) = no two
4	=LAMBDA(p_one, p_two, IF(AND(ISOMITTED(p_one), ISOMITTED(p_two)), "empty", p_one+p_two))(, ) = empty
5	=LAMBDA(p_one, [p_two], p_one+p_two)(1,2) = 3
6	=LAMBDA(p_one, [p_two], p_one+p_two)(1) = 1
7	=LAMBDA(p_one, [p_two], p_one*p_two)(1) = 0

1 - Assuming that you will always get both parameters.
2 - How to check if the first parameter is missing.
3 - How to check if the second parameters is missing.
4 - How to check if both parameters are missing.
5 - How to declare an optional argument.
6 - How to declare an optional argument. The value is assumed to be zero.
7 - How to declare an optional argument. The value is assumed to be zero.