Spread Formula Reference
PROB
Formula Functions > Functions M to Q > PROB

This function returns the probability that values in a range are between two limits.

Syntax

PROB(array,probs,lower,upper)

Arguments

This function has these arguments:

Argument Description
array Array of numeric values, which has corresponding probs
probs Probabilities associated with the numeric values in array
lower Lower limit on the numeric value for which you want a probability
upper [Optional] Upper limit on the numeric value for which you want a probability; if omitted, returns the probability of result equal to lower limit

Remarks

If the upper argument is not provided, the function uses the value for the lower argument only, and returns the probability that the values are equal to the lower argument.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

PROB({B1:B6},{E1:E6},10,100)

PROB({B2,B4,B5,B7},{0.4,0.25,0.1,.025),10,100)

PROB({R1C2:R6C2},{R1C5:R6C5},1,50)

PROB({0,1,2,3},{0.2,0.3,0.1,0.4},2) gives the result 0.1

Version Available

This function is available in product version 1.0 or later.

See Also

BINOMDIST | CRITBINOM | Statistical Functions