BINOMDIST

Definition: BINOMDIST is a function that returns the individual term binomial distribution probability.

Syntax: =BINOMDIST(number_s, trials, probability_s, [cumulative])

Situation: This formula is suitable when you need to find the probability of a number of successes in a fixed number of trials with a known probability of success.

Example: If you have a binomial distribution with 10 trials and a probability of success of 0.4, the probability of getting exactly 4 successes can be found using the formula =BINOMDIST(4, 10, 0.4, FALSE), which returns a value of 0.2508.