“Two heads in three flips” can mean exactly two heads or at most two. The last argument of BINOM.DIST controls which result appears in the workbook.

Ask for exactly two heads

Use 2 in A2, 3 in B2 and 0.5 in C2 for the target, trial count and probability of heads. This example assumes independent flips of a fair coin.

=BINOM.DIST(A2,B2,C2,FALSE)

There are eight equally likely sequences. The ones with exactly two heads are HHT, HTH and THH, so the result is 3/8, or 0.375.

Of the eight possible three-flip sequences, HHT, HTH and THH contain exactly two heads.

Illustrated outcomes for independent fair flips. Each sequence has probability one eighth.

Compare the cumulative result

Change FALSE to TRUE in a separate formula. Now the result includes zero, one and two heads. Only HHH is excluded, so the answer is 7/8, or 0.875. Label the cells Exactly two and At most two before formatting them as percentages.

The exact case is 0.375. The cumulative case is 0.875 because it includes zero, one and two heads.

Illustrated probability check. The final argument determines which question the formula answers.

Microsoft’s Excel function reference