Excel like a finance pro.
← The libraryPractice · 2 questions →
Logical function
ISOMITTED
Tests whether an optional LAMBDA parameter was left out.
Rarely usedDifficulty 1750 · ExpertUsage rank #503 of 520
When to use it
Inside a LAMBDA, TRUE when an optional parameter was not supplied. The way to give parameters default values.
The shape of it
- Syntax
=ISOMITTED(argument)
Worked examples
Omitted
=LAMBDA(x,[y],IF(ISOMITTED(y),x,x+y))(5) → 5
y omitted, so just x.
Supplied
=LAMBDA(x,[y],IF(ISOMITTED(y),x,x+y))(5,3) → 8
y supplied.
Default value
=LAMBDA(rate,[periods],LET(n,IF(ISOMITTED(periods),12,periods),(1+rate)^n-1))(0.01) → 0.126825
A default of 12 periods.
Worth knowing
- Optional parameters are declared in square brackets.
- Combine with LET to set the default once.
- Only meaningful inside LAMBDA.
Where it goes wrong
- Returns FALSE for an argument passed as empty text, since that is a value.
- Requires Microsoft 365.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.