Skip to Content

BINOMDIST

Returns the individual term binomial distribution probability. Replaced by BINOM.DIST.

Syntax

BINOMDIST(number_s, trials, probability_s, cumulative)

Parameters

  • number_s: Required. The number of successes in trials
  • trials: Required. The number of independent trials
  • probability_s: Required. The probability of success on each trial
  • cumulative: Required. A logical value: TRUE for cumulative distribution, FALSE for probability mass

Example

=BINOMDIST(6, 10, 0.5, FALSE)
Returns: NumberSince: Excel 2003