# A to Z of Excel Functions: The PROB Function

5 February 2024

*Welcome
back to our regular A to Z of Excel Functions blog. Today we look at the PROB function. *

** **

**The
PROB function**

I have no **PROB** with this function. It returns the probability that values in a
range (to be specified) are between two limits.
If the upper limit is not specified, **PROB **returns the probability
that the value in the **x_range **is equal to the lower limit.

The **PROB **function
uses the following syntax to operate:

**PROB(x_range, probability_range, lower_limit, [upper_limit])**

The **PROB** function has the following arguments:

**x_range:**this is required and represents the range of numerical values of**x**with which there are associated probabilities**probability_range:**this is also required, and denotes a set of probabilities associated with the values in the**x_range****lower_limit:**this is required and cites the lower bound on the value for which you want a probability**upper_limit:**this argument is optional and represents the upper bound on the value for which you require a probability.

It should be further noted that:

- if any value in
**probability_range**≤ 0 or if any value in**probability_range**> 1,**PROB**returns the*#NUM!*error value - if the sum of the values
in
**probability_range**is not equal to 1,**PROB**returns the*#NUM!*error value - if
**upper_limit**is omitted,**PROB**returns the probability of being equal to the**lower_limit** - if
**x_range**and**probability_range**contain a different number of data points,**PROB**returns the*#N/A*error value.

Please see my example below:

*We’ll
continue our A to Z of Excel Functions soon.
Keep checking back – there’s a new blog post every other business day.*

*A
full page of the function articles can be found here. *