Calculates the probability that a random value chosen falls between two given limits.
Syntax
PROB(values; probabilities; [start]; [end])
values: A range or array of numbers. Eg., A2:A5
Examples
Formula |
Result |
=PROB(A2:A5;B2:B5;C2) |
0.2 |
=PROB(A2:A5;B2:B5;C3;D3) |
0.55 |
=PROB(A2:A5;B2:B5;C4) |
0.25 |
Possible Errors
Errors |
Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
#NUM! |
|
Similar Functions
BINOMDIST
CRITBINOM
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com