ISOMITTED
Checks whether the value in a LAMBDA is missing and returns TRUE or FALSE.
InformationInformation & AuditingModern Excel Functions
What it does
Checks if an optional parameter in a LAMBDA function was skipped.
Syntax
ISOMITTED(argument)
Arguments
argument(value) — The LAMBDA argument to check.
Examples
Check Missing Arg
Check if param is missing (Conceptual).
FORMULA
=LAMBDA(x,y, IF(ISOMITTED(y), x, x+y))
RESULT
(Lambda)
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | (Function) |