📎 This article includes 1 downloadable practice file ↓
In this article
PROB adds the probabilities of outcomes falling between two limits, from a simple value/probability table.
Syntax
=PROB(x_range, prob_range, lower_limit, [upper_limit])| Argument | What it means |
|---|---|
prob_range |
Must add up to 1. |
Examples
Example 1
=PROB(A2:A7, B2:B7, 3, 5)Chance of selling 3 to 5 units a day from a demand table.
PROB in practice
Where you will use it
- Chance a value falls in a range from a probability table
- Simple risk tables
- Teaching probability
Worked example
Values 1-4 with probabilities 0.1-0.4.
| Low | High | Formula | Result |
|---|---|---|---|
| 1 | 2 | =PROB({1,2,3,4},{0.1,0.2,0.3,0.4},A2,B2) | 0.3 |
| 3 | 3 | =PROB({1,2,3,4},{0.1,0.2,0.3,0.4},A3,B3) | 0.3 |
| 2 | 4 | =PROB({1,2,3,4},{0.1,0.2,0.3,0.4},A4,B4) | 0.9 |
Results calculated in Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Probabilities not adding to 1 | PROB returns #NUM! |
| Lower > upper | Swap them |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
⚡ Interactive Practice Lab & Formula Tester:
Test formulas dynamically in our web formula laboratory or download the companion Excel workbook.
📎 Practice files for this article
- 📗Practice workbook: Statistics advanced33 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.⬇ XLSX · 36 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong