ISOMITTED function
ISOMITTED returns TRUE if the caller left out an optional argument. It is used inside a LAMBDA to check whether an optional parameter was supplied, and only makes sense for parameters in square brackets.
Example
Read it as a sentence: build a function from x and an optional y, run it with just 1, and say none when y was left out, which gives none.
A
B
C
D
1
none
2
3
Syntax
ISOMITTED(argument)
-
argument(required) - A parameter name inside a LAMBDA.
Returns: TRUE if the caller left that optional argument out.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=LAMBDA(a,b,ISOMITTED(b))(1,) | TRUE | Omitted with comma |
=LAMBDA(a,b,ISOMITTED(b))(1,2) | FALSE | Supplied |
=LAMBDA(a,b,IF(ISOMITTED(b),"no b",b))(1,) | no b | Default idiom |
=ISOMITTED(1) | FALSE | Outside lambda |
=LAMBDA(a,ISOMITTED(a))("") | FALSE | Empty text supplied |
=LAMBDA(a,b,ISOMITTED(b))(1) | #VALUE! | Missing entirely |
Watch out for
- Only meaningful for parameters in square brackets.
- Only works inside a LAMBDA.
Where it works
- Excel
- ISOMITTED arrived in Excel 2024. Older versions do not have it. Needs a version with LAMBDA; may not be in older perpetual versions.
- Google Sheets
- Same name, same behaviour for everyday use. Sheets also has ISOMITTED; verify in your edition.
Part of Information functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .