PROB (PQL  xl)
This function returns the probability that values in a range are between two limits
 Library: PQL \ Spreadsheet \ Statistical
 Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
PROB(x range, prob range, lower limit, upper limit)
Function Arguments
Name  Description  Type  Optional 
x range  Array of numeric values, which has corresponding probs  StringOrNumber 

prob range  Probabilities associated with the numeric values in array  StringOrNumber 

lower limit  Lower limit on the numeric value for which you want a probability  Number 

upper limit  Upper limit on the numeric value for which you want a probability; if omitted, returns the probability of result equal to lower limit  Number 

Comments
This function is the same as the Microsoft Excel 'PROB' function  using the same inputs, logic and outputs.