Formulas > =PROB()
How to Use PROB() in Google Sheets
Description
How To Actually Use PROB() in Sheets
PROB(data, probabilities, low_limit, [high_limit])
Try PROB yourself
In cells A1:A10, enter a set of values and in B1:B10, enter their corresponding probabilities. Use the PROB formula to calculate the probability that a randomly chosen value falls between 10 and 20 in cell D1.
Hints (2)
-
Make sure your data and probabilities are in the same rows.
-
Check that your low and high limits are correctly set in the formula.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the PROB() formula:
Generate a PROB() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses PROB(). 2 free AI generations, no signup. Members get unlimited use.
Generate a PROB() formula