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

Want to practice PROB in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=PROB(x_range, prob_range, [lower_limit], [upper_limit])

Arguments

ArgumentRequired?What it does
x_rangeYesThe outcomes.
prob_rangeYesThe probability of each outcome, the same size; must total 1.
lower_limitNoThe lowest outcome to include.
upper_limitNoThe 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.

E2fx=PROB(A2:A6,B2:B6,2,3)
ABCDE
1OrdersProbabilityMeasureResult
200.12 or 3 orders0.55
310.25Exactly 40.1
420.3
530.25
640.1
=PROB(A2:A6,B2:B6,2,3) Explain

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

Kyle Stott

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.