📎 This article includes 1 downloadable practice file ↓
In this article
ISOMITTED is used inside LAMBDA to give optional parameters default values.
Syntax
=ISOMITTED(argument)| Argument | What it means |
|---|---|
argument |
A LAMBDA parameter. |
Examples
Example 1
=LAMBDA(amt, [rate], amt * IF(ISOMITTED(rate), 18%, rate))A GST function that uses 18% unless you pass another rate.
ISOMITTED in practice
Where you will use it
- Optional arguments in your own LAMBDA functions
- Default values in custom functions
- Reusable named formulas
Worked example
Default GST rate 18% unless a rate is passed.
| Call | Formula | Result |
|---|---|---|
| Tax(1000) | =CHOOSE(ROW()-1,LAMBDA(a,[r],a*IF(ISOMITTED(r),0.18,r))(1000),LAMBDA(a,[r],a*IF(ISOMITTED(r),0.18,r))(1000,0.05),LAMBDA(a,[r],a*IF(ISOMITTED(r),0.18,r))(500)) | 180 |
| Tax(1000, 0.05) | =CHOOSE(ROW()-1,LAMBDA(a,[r],a*IF(ISOMITTED(r),0.18,r))(1000),LAMBDA(a,[r],a*IF(ISOMITTED(r),0.18,r))(1000,0.05),LAMBDA(a,[r],a*IF(ISOMITTED(r),0.18,r))(500)) | 50 |
| Tax(500) | =CHOOSE(ROW()-1,LAMBDA(a,[r],a*IF(ISOMITTED(r),0.18,r))(1000),LAMBDA(a,[r],a*IF(ISOMITTED(r),0.18,r))(1000,0.05),LAMBDA(a,[r],a*IF(ISOMITTED(r),0.18,r))(500)) | 90 |
Results calculated in Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Outside LAMBDA | Only works for LAMBDA parameters |
| Square brackets | Mark optional parameters with [ ] |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
⚡ Interactive Practice Lab & Formula Tester:
Test formulas dynamically in our web formula laboratory or download the companion Excel workbook.
📎 Practice files for this article
- 📗Practice workbook: Logic, LET & LAMBDA17 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.⬇ XLSX · 35 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong