PROB Function Explained
The PROB function in Microsoft Excel calculates the probability that values in a range are between two limits. It takes three arguments: a range of values, the lower limit, and the upper limit. It returns the probability that values in the range are between the two limits.
PROB Function Syntax
PROB(x_range,prob_range,lower_limit,upper_limit)
x_range– The range of values that can be returned by the function.prob_range– The range of probabilities associated with the values in the x_range.lower_limit– The lower limit of the range of values to consider.upper_limit– The upper limit of the range of values to consider.