PROB
Probability that values fall within limits.
- Excel: Not checked yet
- Google Sheets: Not checked yet
- Returns: Number
Examples
=PROB(P1:P4, Q1:Q4, 2, 3) | P | Q | |
|---|---|---|
| 1 | 1 | 0.1 |
| 2 | 2 | 0.2 |
| 3 | 3 | 0.3 |
| 4 | 4 | 0.4 |
Result 0.5
Syntax
PROB(x_range, prob_range, lower_limit, [upper_limit])x_range- range required
prob_range- range required
lower_limit- number required
upper_limit- number optional
Errors
#NUM!=PROB(A1:A3, A1:A3, 2)