Please note javascript is required for full website functionality.


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