PROB(x_range,prob_range,lower_limit,upper_limit)
x_range: possible values
prob_range: probabilities of the corresponding values
lower_limit: lower interval limit
upper_limit: upper interval limit, defaults to lower_limit
If the sum of the probabilities in prob_range is not equal to 1 this function returns a #NUM! error. If any value in prob_range is <=0 or > 1, this function returns a #NUM! error. If x_range and prob_range contain a different number of data entries, this function returns a #N/A error.
This function is Excel compatible.