The PROB function returns the probability that values in a range are between two limits.

### Syntax

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

#### Arguments

Argument Description
x_range The range of numeric values of x with which there are associated probabilities
prob_range A set of probabilities associated with values in x_range
lower_limit The lower bound on the value for which you want a probability
[upper_limit] Optional. The optional upper bound on the value for which you want a probability

 • If upper_limit is omitted, the function returns the probability associated with the value of the supplied lower_limit

#### Examples

A B C D
1 Value of x Probability
2 0 0.1
3 1 0.25
4 2 0.3
5 3 0.35
6
7 Formula Result Notes
8 =PROB(A2:A5,B2:B5,2) 0.3 Probability that x is 2
9 =PROB(A2:A5,B2:B5,1,3) 0.9 Probability that x is between 1 and 3

#### Common Function Error(s)

Problem What went wrong
#NUM! Occurs if either:

 • any value in the supplied prob_range is < 0 or > 1 • the values in the supplied prob_range do not add up to 1
#N/A Occurs if the supplied x_range and prob_range arrays are of different lengths, i.e. contain different numbers of data points