Syntax. BINOM.DIST(number_s;trials;probability_s;cumulative)

Definition. This function returns the probabilities of a binomial distributed random variable. Use the BINOM.DIST() function for problems with a fixed number of tests or trials when the results of a trial are only success or failure, when trials are independent, and when the probability of success is constant throughout all trials. For example, you can use the BINOM.DIST() function to calculate the probability that 50 of 100 people in a restaurant support a smoking ban.


  • number_s (required). The number of successes in trials.

  • trials (required). The number of independent trials.

  • probability_s (required). The probability for the success of each trial.

  • cumulative ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.