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 Excel BINOM.DIST function returns the Binomial Distribution probability for a given number of successes from a specified number of trials.
The function is new in Excel 2010 and so is not available in earlier versions of Excel. However, the Binom.Dist function is simply an updated version of the Binomdist function that is available in earlier versions of Excel.
The syntax of the Binom.Dist function is:
where the arguments are:
number_s    The number of successes that you want to calculate the probability for.  
trials    The number of independent trials that are to be done.  
probability_s    The probability of success in one trial.  
cumulative    A logical argument that specifies the type of Binomial distribution to be calculated. This can have the value TRUE or FALSE meaning:

Note that, if decimal values are input for the number_s or trials arguments, these are truncated to integers by Excel.
The above chart on the right uses the Binomial Distribution Probability Mass Function to show the probability that exactly x heads will be thrown from 100 tosses of a coin.
In column A of the spreadsheet below, the Excel Binom.Dist function is used to evaluate this function for three different values of x.
Clearly, the probability of tossing a head on any one trial is 0.5, so this is input as the value of the probability_s argument in each case.
Formulas:
 Results:

The above chart on the right shows the Binomial Cumulative Distribution Function for the probability of throwing at most x heads from 100 tosses of a coin.
In column A of the spreadsheet below, the Excel Binom.Dist function is used to evaluate this function for three different values of x.
Again, the probability of tossing a head on any one trial is 0.5, so this is input as the value of the probability_s argument.
Formulas:
 Results:

Further examples of the Excel Binom.Dist function are provided on the Microsoft Office website.
If you get an error from the Excel Binom.Dist Function, this is likely to be one of the following:
#NUM!    Occurs if either:

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