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
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
Arguments
| Argument | Required? | What it does |
|---|---|---|
| trials | Yes | The number of independent tries. |
| probability_s | Yes | The chance of success on each try. |
| alpha | Yes | The target cumulative probability, between 0 and 1. |
Examples
Example 1 — Planning call outcomes
20 calls with a 15% close rate.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Calls | 20 |
| 3 | Close rate | 0.15 |
| 4 | Median sales | 3 |
| 5 | 90% of days, at most | 5 |
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.
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
- BINOM.INV replaces the older CRITBINOM function.
- Related functions: BINOM.DIST, BINOM.DIST.RANGE.

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.