ISOMITTED Function

Checks whether an optional LAMBDA argument was left out.

Category

Information

Available in

Microsoft 365, Excel 2024

Returns

TRUE or FALSE

Want to practice ISOMITTED in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

ISOMITTED is used inside LAMBDA. When you mark a parameter as optional by putting it in square brackets — [rate] — ISOMITTED tells you whether the person calling the function supplied it.

That lets your custom functions have sensible defaults, just like Excel's own optional arguments.

Syntax

=ISOMITTED(argument) Explain

Arguments

ArgumentRequired?What it does
argumentYesThe name of one of the LAMBDA's parameters.

Examples

Example 1 — A default tax rate

Add 20% tax unless a different rate is given.

C2fx=LAMBDA(amount,[rate],amount*(1+IF(ISOMITTED(rate),0.2,rate)))(A2)
ABC
1NetRate givenWith tax
2100(none)120
3250(none)300
=LAMBDA(amount,[rate],amount*(1+IF(ISOMITTED(rate),0.2,rate)))(A2)

Calling it with a rate — (A2,0.05) — gives 105 for the first row.

Example 2 — Save it as a named function

Formulas › Name Manager › New. Name: ADDTAX. Refers to:

=LAMBDA(amount,[rate],amount*(1+IF(ISOMITTED(rate),0.2,rate)))
  1. Now =ADDTAX(A2) uses 20%.
  2. =ADDTAX(A2,0.05) uses 5%.
  3. =ADDTAX(A2,) — with a trailing comma — also counts the rate as omitted.

Common mistakes

  • Leaving out a parameter that isn't in brackets. Only parameters written as [name] may be skipped. Leaving out a required one gives #VALUE!.

Notes

  • Optional parameters must come after the required ones.
  • Related functions: LAMBDA, LET, IF.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.