BINOM.DIST(number_s, trials, probability_s, cumulative)
- number_s - The number of successes for which to calculate the probability.
- trials - The number of independent trials.
- probability_s - The probability of success in any given trial.
- cumulative - A logical value that determines the form of the function.
BINOM.DIST(C2,C3,C4,FALSE) returns the probability of exactly 6 of 10 trials being successful.
BINOM.DIST(4,100,0.005,FALSE) returns a value of 0.00151.