Skip to content
ExcelExcel 2024+

ISOMITTED function in Excel

Checks whether the value in a LAMBDA is missing and returns TRUE or FALSE

=ISOMITTED(argument)

ISOMITTED syntax and parameters

One argument, one required.

  • argumentanyRequired

ISOMITTED examples

Formulas you'll actually reuse.

  1. An optional LAMBDA argument — no discount passed, so the price comes back unchanged:

    =LAMBDA(price, [discount], IF(ISOMITTED(discount), price, price * (1 - discount)))(C2)

    Result1250

  2. The same LAMBDA with the optional argument supplied:

    =LAMBDA(price, [discount], IF(ISOMITTED(discount), price, price * (1 - discount)))(C2, 0.1)

    Result1125

ISOMITTED in Google Sheets

No direct equivalent — here's the way around.

Try ISOMITTED in the playground

Edit the example — nothing to install.

Preloaded with the ISOMITTED formula from Example 1 — change anything and watch it respond.

Loading the editor…

ISOMITTED errors

What they mean — and the fixes.

  • #VALUE!

    ISOMITTED only works on a LAMBDA parameter — outside a LAMBDA there is nothing that can be omitted.

Related functions

More ways Excel gets this done.