BINOM.DIST returns probability as a decimal number between 0 and 1.

Binary data shows up when an observation can be placed into only two categories.

For example, when tossing a coin, the result can only be heads or tails.

Excel BINOM.DIST function

Or, when rolling a die, the result can either be 6 or not 6.

Since a die has six sides, the probability of rolling a 6 is 1/6, or 0.1667.

The probability of rolling one 6 in 10 trials is about 32%.

The formula in D5 is the same, except thecumulativeargument has been set to TRUE.