ISOMITTED

ISOMITTED(argument)

Returns the boolean 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 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.

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