BINOM.INV Function

Returns the smallest number of successes whose cumulative binomial probability reaches a target.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A whole number

Want to practice BINOM.INV 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

BINOM.INV finds the smallest k for which the chance of at most k successes is at least alpha. It's used for planning and quality limits: "what's the most defects we'd expect 95% of the time?"

Syntax

=BINOM.INV(trials, probability_s, alpha) Explain

Arguments

ArgumentRequired?What it does
trialsYesThe number of independent tries.
probability_sYesThe chance of success on each try.
alphaYesThe target cumulative probability, between 0 and 1.

Examples

Example 1 — Planning call outcomes

20 calls with a 15% close rate.

B5fx=BINOM.INV(B2,B3,0.9)
AB
1MeasureValue
2Calls20
3Close rate0.15
4Median sales3
590% of days, at most5
=BINOM.INV(B2,B3,0.9) Explain

On 90% of days, a rep making 20 calls closes 5 or fewer.

Example 2 — A quality control limit

Batches of 100 with a 2% defect rate: more than this many defects happens less than 5% of the time.

=BINOM.INV(100,0.02,0.95) Explain

Returns 5 — investigate batches with more than 5 defects.

Common mistakes

  • #NUM! trials is negative, probability_s is outside 0–1, or alpha is outside 0–1.

Notes

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.