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

The BINOMDIST 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 BINOMDIST function is outdated and replaced by the BINOM.DIST function.

Formula in cell C8:

=BINOMDIST(C3,C4,C5,C6)

Excel Function Syntax

BINOMDIST(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 BINOMDIST 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.

Excel Function Reference

This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.