ExcelFlux

ISOMITTED function

Check — whether the value in a LAMBDA is missing and returns TRUE or FALSE.

Information · Excel 2024+ · Guided Excel example

Where can you use it?

Workbook and data quality owners. Use functions that inspect cell type, errors or the calculation environment when validating a report.

Scenario in the workbook

A supplied lambda argument is not omitted.

A worked example from the workbook

RowA
6Trial
71
82
93
Record 1
=LAMBDA(x,ISOMITTED(x))(A7)

Illustrative outputFALSE

See the inputs and instructions for all 3 examples

Worked examples

A supplied lambda argument is not omitted.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Trial
7 1
8 2
9 3
Trial Expression Sample output
Record 1 =LAMBDA(x,ISOMITTED(x))(A7) FALSE
Record 2 =LAMBDA(x,ISOMITTED(x))(A8) FALSE
Record 3 =LAMBDA(x,ISOMITTED(x))(A9) FALSE
Microsoft Excel reference