EXPON.DIST Function
Returns the exponential distribution — for the time until the next event.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
The exponential distribution models waiting times between random events that happen at a steady average rate: the next support ticket, the next customer, the next machine fault.
lambda is the rate — events per unit of time — so 1 ÷ lambda is the average wait. A ticket every 10 minutes on average means lambda = 0.1.
TRUE returns the cumulative probability (the chance of a value up to x); FALSE returns the probability density — the height of the curve, not a probability.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The waiting time; can't be negative. |
| lambda | Yes | The rate (1 ÷ average wait); must be greater than 0. |
| cumulative | Yes | TRUE for the cumulative probability, FALSE for the density (height of the curve). |
Examples
Example 1 — Will a ticket arrive within 5 minutes?
Tickets arrive on average every 10 minutes.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Average wait (min) | 10 |
| 3 | Rate (lambda) | 0.1 |
| 4 | Within 5 min | 0.3935 |
| 5 | Quiet for 20+ min | 0.1353 |
About a 39% chance of a ticket in the next 5 minutes, and about 14% that 20 minutes pass with none.
Common mistakes
- Passing the average instead of the rate. lambda is events per unit of time. For an average of 10 minutes, use 0.1 (or 1/10), not 10.
- #NUM! x is negative, or lambda is 0 or negative.
Notes
- Related functions: POISSON.DIST (number of events in a period), WEIBULL.DIST, GAMMA.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.