Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .