Practice free

BINOM.DIST function

BINOM.DIST tells you how likely it is to get a set number of successes in a fixed number of yes/no trials, such as defective items in a batch or conversions from sales calls.

Example

Read it as a sentence: find the chance of getting 3 or fewer successes in 10 tries when each try has a 50% chance.

Practice this in the app

Syntax

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

number_s (required)
Number of successes.
trials (required)
Number of independent trials.
probability_s (required)
Chance of success on each trial.
cumulative (required)
TRUE for chance of at most number_s successes, FALSE for exactly that many.

Returns: The binomial probability of the given number of successes.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=BINOM.DIST(3,10,0.5,TRUE) 0.171875 Working example
=BINOM.DIST(3,10,0.5,FALSE) 0.1171875 Other cumulative flag
=BINOM.DIST(3,10,0.5,0) 0.1171875 Cumulative as 0
=BINOM.DIST("3",10,0.5,TRUE) 0.171875 Text-number in first arg
=BINOM.DIST({3,3},10,0.5,TRUE) 0.171875 Array in first arg (lifts, spills)
=BINOM.DIST(3.7,10,0.5,FALSE) 0.1171875 Fractional successes truncated
=BINOM.DIST("abc",10,0.5,TRUE) #VALUE! Non-numeric text in first arg
=BINOM.DIST(NA(),10,0.5,TRUE) #N/A Error in first arg

Watch out for

  • number_s and trials are truncated to whole numbers.
  • TRUE gives 'at most', not 'exactly'; people often mix these up.

Where it works

Excel
BINOM.DIST arrived in Excel 2010. Older versions do not have it.
Google Sheets
Same name, but behaves differently. Google Sheets supports BINOM.DIST and the older BINOMDIST with the same arguments.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .