NEGBINOM.DIST Function
Returns the probability of a number of failures before a set number of successes.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
NEGBINOM.DIST flips the binomial question: instead of a fixed number of tries, you keep going until you reach number_s successes, and it returns the chance of exactly (or at most) number_f failures along the way.
With cumulative FALSE it's exactly number_f failures; with TRUE, at most number_f.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number_f | Yes | The number of failures. |
| number_s | Yes | The number of successes you're waiting for. |
| probability_s | Yes | The chance of success on each try. |
| cumulative | Yes | TRUE for at most number_f failures; FALSE for exactly number_f. |
Examples
Example 1 — Calls before the second sale
With a 15% close rate, how likely is it to need no more than 6 unsuccessful calls before landing 2 sales?
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Failed calls | 6 |
| 3 | Sales wanted | 2 |
| 4 | Close rate | 0.15 |
| 5 | Exactly 6 fails | 0.0594 |
| 6 | At most 6 fails | 0.3428 |
Only about a 34% chance of 2 sales within the first 8 calls.
Common mistakes
- Failures, not tries. number_f counts only the unsuccessful attempts. Total calls = number_f + number_s.
- #NUM! probability_s is outside 0–1, number_f is negative or number_s is less than 1.
Notes
- NEGBINOM.DIST replaces the older NEGBINOMDIST function.
- Related functions: BINOM.DIST, EXPON.DIST.

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.