BINOM.DIST.RANGE in WPS on Windows FAQ

When using BINOM.DIST.RANGE, common questions usually involve formula errors, parameter meaning, and result checking; this FAQ covers 3 frequent questions and includes a short glossary.

FAQ

What should I do if BINOM.DIST.RANGE returns an error?

1. Check whether the formula starts with =.
2. Check whether the parentheses, commas, and argument count are complete.
3. Make sure the arguments are numeric and that the probability and success-count values are entered correctly.
4. Review the syntax prompt and enter the formula again if needed.

How do I tell the difference between an exact-success result and a range result?

1. When you enter only the required arguments for the exact count, the function returns the probability for a specific number of successes.
2. When you also enter the optional upper bound, the function returns the probability for a success-count range.
3. Try both forms in the same worksheet to compare the results directly.

What should I check if the result does not look right?

1. Check whether the number of trials, success probability, and success counts match the same scenario.
2. Check whether referenced cells contain numbers stored as text.
3. Check whether the start and end values of the range were entered in the wrong order.
4. Reconfirm the formula after editing values so the worksheet recalculates the result.

Glossary