Returns the probability of drawing a specific number of successes or range of successes given a probability and number of tries.
Academy ↓
Formulas > =BINOM.DIST.RANGE()
How To Use BINOM.DIST.RANGE() Function in Google Sheets
Description
How To Actually Use BINOM.DIST.RANGE() in Sheets
BINOM.DIST.RANGE(num_trials, prob_success, num_successes, max_num_successes)
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 BINOM.DIST.RANGE() formula:
Generate a BINOM.DIST.RANGE() formula for your needs with AI
Google Sheets Formula Generator
Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.
Asa
Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.