This function returns the individual term probability from the binomial distribution. The **BINOM.DIST** The function should be used in problems with a fixed number of tests or trials, when the results of any trial are just success or failure, when the trials are independent and when the probability of success is constant throughout the experiment. As an example, **BINOM.DIST** can calculate the probability that two of the next three babies born will be boys.

The **BINOM.DIST **The function uses the following syntax to operate:

**BINOM.DIST (numbers, essays, probability_s, cumulative)**

The **BINOM.DIST** The function has the following arguments:

**numbers:**this is necessary and represents the number of successes in trials**essays:**this is also necessary. This is the number of independent trials**probability_s:**again, required. This is the probability of success in each test.**cumulative:**additionally required. This is a logical value that determines the shape of the function. And**cumulative**it is**TRUE**, subsequently**BINOM.DIST**returns the cumulative distribution function, which is the probability that there is at most**numbers**successes Yes**cumulative**it is**FALSE**, returns the probability mass function, what is the probability that there are**numbers**successes.

It should be noted at the same time that:

**numbers**Y**trials**they are truncated to integers- And
**numbers**,**trials**, O**probability_s**it is / they are non-numeric,**BINOM.DIST**return the*#VALUE!*error value - And
**numbers**<0 O**numbers**>**trials**,**BINOM.DIST**return the*#ON ONE!*error value - And
**probability_s**<0 O**probability_s**> 1,**BINOM.DIST**return the*#ON ONE!*error value.

The binomial probability mass function is: