Returns the individual term binomial distribution probability.
BINOMDIST(X; Trials; SP; C)
X is the number of successes in a set of trials.
Trials is the number of independent trials.
SP is the probability of success on each trial.
C = 0 calculates the probability of a single event and C = 1 calculates the cumulative probability.
=BINOMDIST(A1;12;0.5;0) shows (if the values 0 to 12 are entered in A1) the probabilities for 12 flips of a coin that Heads will come up exactly the number of times entered in A1.
=BINOMDIST(A1;12;0.5;1) shows the cumulative probabilities for the same series. For example, if A1 = 4, the cumulative probability of the series is 0, 1, 2, 3 or 4 times Heads (non-exclusive OR).