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

Returns the probability that values in a range are between two limits.

 x_range The range of numeric values of x with which there are associated probabilities. prob_range The 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 upper bound on the value for which you want a probability.

#### Remarks

 * If "upper_limit" is not supplied, returns the probability that values in "x_range" are equal to "lower_limit".* If any value in "prob_range" = 0 or if any value in "prob_range" > 1, then #NUM! is returned.* If the sum of the values in "prob_range" = 1, then #NUM! is returned.* If "upper_limit" is left blank, then the probability of being equal to "lower_limit" is returned.* If "x_range" and "prob_range" contain a different number of data points, then #N/A is returned.* For the Microsoft documentation refer to support.office.com

 A 1 =PROB({0,1,2,3},{0.2,0.3,0.1,0.4},2) = 0.1 2 =PROB({0,1,2,3},{0.2,0.3,0.1,0.4},1,3) = 0.8