The BINOM.DIST function returns the binomial distribution probability for a given number of successes from a specified number of trials.
 This function was introduced in Excel 2010 and so is not available in earlier versions.
 BINOM.DIST replaces the BINOMDIST function included in earlier versions of Excel.
Syntax
=BINOM.DIST(number_s,trials,probability_s,cumulative)
Arguments
Argument  Description  

number_s  The number of successes in trials  
trials  The number of independent trials  
probability_s  The probability of success on each trial  
cumulative  A logical argument that specifies the type of binomial distribution to be calculated. This can have the value TRUE or FALSE meaning:

Examples
A  B  C  D  

1  Data  Formula  
2  6  Number of successes in trial  
3  10  Number of independent trials  
4  0.5  Probability of success on each trial  
5  
6  Formula  Result  Notes  
7  =BINOM.DIST(A2,A3,A4,FALSE)  0.2050781  Probability of exactly 6 of 10 trials being successful 
Usage note: Use BINOM.DIST in problems with a fixed number of tests or trials, when the outcomes of any trial are only success or failure, when trials are independent, and when the probability of success is constant throughout the experiment. For example, BINOM.DIST can calculate the probability that two of the next three babies born are male.
Common Function Error(s)
Problem  What went wrong  

#VALUE!  Occurs if any of the number_s, trials, or probability_s arguments are nonnumeric  
#NUM!  Occurs if either:

The Binomial Distribution is a statistical measure that is frequently used to indicate the probability of a specific number of successes occurring from a specific number of independent trials.
The following two forms are used:
 The Probability Mass Function – calculates the probability of there being exactly x successes from n independent trials
 The Cumulative Distribution Function – calculates the probability of there being at most x successes from n independent trials
The binomial probability mass function is:
The cumulative binomial distribution is:
See Wikipedia for more information on binomial distribution.