Excel BINOM.DIST Function Generator

The BINOM.DIST function calculates the binomial distribution probability for a specific number of successes from a given number of trials.
Enter the number of successful outcomes you want to calculate the probability for. Example: If you're calculating the probability of getting 3 heads in 5 coin flips, enter "3". Can be a cell reference (e.g., A1).
Please enter a valid number or cell reference.
Enter the total number of independent trials. Example: For 5 coin flips, enter "5". Can be a cell reference (e.g., B1).
Please enter a valid number or cell reference.
Enter the probability of success on each trial (between 0 and 1). Example: For a fair coin, enter "0.5". Can be a cell reference (e.g., C1).
Please enter a valid probability between 0 and 1 or a cell reference.
Select whether to calculate the cumulative distribution (TRUE) or the probability mass function (FALSE).

A few examples of using BINOM.DIST function

Scenario Formula Remarks
Find the Probability of Exactly 3 Successes =BINOM.DIST(3, 5, 0.6, FALSE) Returns the probability P(X = 3)
Probability of 3 or Fewer Successes =BINOM.DIST(3, 5, 0.6, TRUE) Returns P(X ≤ 3) (probability of making 0, 1, 2, or 3 shots)
Find the Probability of Getting No Successes =BINOM.DIST(0, 5, 0.6, FALSE) Returns P(X = 0)
Probability of Getting at Least 3 Successes =1 - BINOM.DIST(2, 5, 0.6, TRUE) Since P(X ≥ 3) = 1 - P(X ≤ 2)