# PROB function in Excel

This article describes the formula syntax and usage of the PROB function in Excel. This function returns the probability that values ​​in a range are between two limits. If upper_limit is not available, the function returns the probability that the values ​​in x_range are equal to lower_limit.

PROB is a calculation function that produces the probability that values ​​in a range fall between two limits. Jaw PROB is also one of the functions in the group of statistical functions that are very popular in Excel.

How to use the PROB function in MS Excel

## PROB function in Excel

1. Prob function syntax

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

Inside:

X_range is the range of numerical values ​​of X with the probabilities associated with it.
Prob_range is a probability set associated with values ​​in X_range.
Lower_limit is the lower bound of the value you want to get the probability of.
Upper_limit is the upper bound of the value you want to get the probability of.

2. Some notes:

– If any value in prob_range ≤ 0 or any value in prob_range> 1, PROB returns the error value #NUM!

– If the sum of values ​​in prob_range is not equal to 1, PROB returns the error value #NUM!

– If upper_limit is omitted, PROB returns the probability equal to lower_limit.

– If x_range and prob_range contain a different number of data points, PROB returns the error value # N / A.

3. Illustrative example

Calculate the probability that values ​​in a range fall between two limits with specific information, such as the spreadsheet image below:

Step 1: Enter the syntax of the function calculated in the cell B7 as follows:

Step 2: You press the key Enter To get the result of the function:

Step 3: Next you calculate the probability that X is between 1 and 4 as follows:

Enter the syntax of the function calculated in the cell B8:

Step 4: You press the key Enter To get the result of the function:

If any value in prob_range ≤ 0 or any value in prob_range> 1, PROB returns the error value. #NUM! As the picture below:

If the sum of the values ​​in prob_range is not equal to 1, PROB returns the error value #NUM!

Here I have completed the tutorial how to use PROB function in Excel, use this function to help you calculate so that the result is the probability that the values ​​in a range are between the limits.

https://thuthuat.taimienphi.vn/ham-prob-rong-excel-44325n.aspx
In addition, you should learn and refer to the basic functions in Excel that Taimienphi.vn introduced, share to see and review formulas and how to use functions in Excel. Good luck!

.