“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.

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.

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



