PROB Function
Returns the probability that values in a range fall between two limits.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number
Overview
PROB works with your own probability table: a list of outcomes and the chance of each. It adds up the probabilities of the outcomes between lower_limit and upper_limit (inclusive).
Leave upper_limit out for the probability of exactly lower_limit. The probabilities must add up to 1.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x_range | Yes | The outcomes. |
| prob_range | Yes | The probability of each outcome, the same size; must total 1. |
| lower_limit | No | The lowest outcome to include. |
| upper_limit | No | The highest outcome to include; if left out, only lower_limit. |
Examples
Example 1 — Large orders per day
From past data, the number of large orders a day follows this table.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Orders | Probability | Measure | Result | |
| 2 | 0 | 0.1 | 2 or 3 orders | 0.55 | |
| 3 | 1 | 0.25 | Exactly 4 | 0.1 | |
| 4 | 2 | 0.3 | |||
| 5 | 3 | 0.25 | |||
| 6 | 4 | 0.1 |
A 55% chance of 2 or 3 large orders on a given day.
Common mistakes
- #NUM! A probability is 0 or less or above 1, or the probabilities don't add up to 1.
- #N/A x_range and prob_range are different sizes.
Notes
- Related functions: SUMPRODUCT, SUMIFS, BINOM.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.