Author: Oscar Cronquist Article last updated on September 25, 2018

The BINOM.DIST function calculates the individual term binomial distribution probability, use this function when

  • the success probability is constant through all trials
  • you know the number of trials
  • the outcome is either a success or failure
  • each trial is independent of the other trials.

The BINOM.DIST function was introduced in Excel 2010 and replaces the outdated BINOMDIST function.

Formula in cell C8:

=BINOM.DIST(C3,C4,C5,C6)

Excel Function Syntax

BINOM.DIST(number_s,trials,probability_s,cumulative)

Arguments

number_s Required. The number of successful tests.
trials Required. How many independent tests.
probability_s Required. The probability of success in each test.
cumulative Required. A boolean value.
TRUE - cumulative distribution function.
FALSE - probability mass function.

Comments

The BINOM.DIST function returns

  • #VALUE! error value if number_s, trials or probability_s argument is non-numeric.
  • #NUM! error value if:
    • number_s <= 0 (zero)
    • number_s > trials
    • probability_s < 0 (zero)
    • probability_s > 1
    • A = B

number_s and trials are converted into integers.