ISOMITTED Function
Checks whether an optional LAMBDA argument was left out.
Category
Information
Available in
Microsoft 365, Excel 2024
Returns
TRUE or FALSE
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
Arguments
| Argument | Required? | What it does |
|---|---|---|
| argument | Yes | The name of one of the LAMBDA's parameters. |
Examples
Example 1 — A default tax rate
Add 20% tax unless a different rate is given.
| A | B | C | |
|---|---|---|---|
| 1 | Net | Rate given | With tax |
| 2 | 100 | (none) | 120 |
| 3 | 250 | (none) | 300 |
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:
- Now =ADDTAX(A2) uses 20%.
- =ADDTAX(A2,0.05) uses 5%.
- =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

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.