ISOMITTED

ISOMITTED(argument)

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

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

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top