BINOM.DIST.RANGE Function (Gnumeric)

• Introduced: First release not established from the evidence cited here.
• Supported in: Gnumeric 1.12.62, confirmed by its function registration. No retirement is established.
• Scope: Desktop Gnumeric with the Statistics Functions plugin. Tables use English comma-separated formulas.
• Checked: October 14, 2026. Tables were recalculated in 1.12.57 and finite reference values independently checked. Version 1.12.62 was source-checked, not executed.

BINOM.DIST.RANGE sums binomial probability masses from start through end, including both endpoints. Trials are independent with constant success probability p. Omitting end requests exactly start successes. It is a registered Gnumeric worksheet function with its own contract, so do not infer a different product’s UI-name or file-format-alias rules. Official function reference.

=BINOM.DIST.RANGE(trials,p,start[,end])

Only bracketed arguments are optional; do not type the brackets. The version-pinned help and evaluator establish the Gnumeric contract.

The table records the tested release’s outputs, with finite mathematical references rounded to twelve decimal places. Keep full precision when using a result in a later calculation.

For five independent trials with success probability 0.4, put 5, 0.4, 2 and 4 in A2:D2. =BINOM.DIST.RANGE(A2,B2,C2,D2) gives 0.6528, the probability of two, three or four successes. Omitting D2 from the call gives 0.3456, the probability of exactly two. The expected count is 5×0.4=2, but that does not mean exactly two successes is certain or even has probability one half.

The equivalent ordinary CDF difference is =BINOMDIST(4,5,0.4,TRUE())-BINOMDIST(1,5,0.4,TRUE()). Subtract at one below the lower bound so the mass at two is retained. Summing the individual masses at 2, 3 and 4 provides another check.

For at least three successes, =BINOM.DIST.RANGE(5,0.4,3,5) gives 0.31744. The total range from zero through trials must have probability 1. When comparing cutoffs, retain full-precision results instead of using rounded percentages as exact decision thresholds.

Gnumeric floors trials, start and end. Its helper returns zero for a reversed interval and naturally includes only the distribution’s support when a bound extends below zero or above trials. The observed examples therefore differ from stricter argument-validation contracts in some applications. Prefer explicit integer bounds with 0≤start≤end≤trials in a portable worksheet. Invalid trial count or probability still produces an error; zero probability is a legitimate result only for a valid modeled event. The interval helper implements these boundary choices.

These additional outcomes were observed in the same native recalculation. F5 was genuinely empty; it is not an omitted argument. Missing inputs still need deliberate validation, even if they are converted to a numeric zero.

The worked calculations do not certify every locale, imported text value, extreme parameter or later binary version. Shared numerical helpers can change even when a function’s wrapper remains the same.

• Gnumeric function reference
• Gnumeric 1.12.62 evaluator

The reference and boundary tables use recorded 1.12.57 command-line recalculation. Further model examples were independently calculated from their stated inputs; they are not additional native test claims.