Formulas > =BINOM.DIST.RANGE()

How To Use BINOM.DIST.RANGE() Function in Google Sheets


Returns the probability of drawing a specific number of successes or range of successes given a probability and number of tries.

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

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.


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.