Collabora Office B: Binomial point and inclusive interval probabilities

=B(Trials; SP; T1 [; T2])

Trials is the total number of trials; SP is the same success probability on every trial. With three arguments, T1 is the exact success count. With four, T1 and T2 bound an inclusive interval of success counts. They are not a second and third number of experiments. Official B help.

The source floors Trials, T1 and T2 before validation. Use whole numbers so that your formula expresses the model clearly. Valid counts satisfy 0 ≤ T1 ≤ Trials, or 0 ≤ T1 ≤ T2 ≤ Trials for the interval form. SP must lie between 0 and 1 inclusive.

This is a binomial model: a fixed number of independent trials, two classified outcomes per trial, and a constant success probability. The function does not establish those assumptions from your data. Sampling without replacement from a small finite population generally needs a different model.

Enter the following inputs:

Use =B(B2;B3;B4). The independent answer is 0.375, or 37.5% when displayed as a percentage. There are six arrangements containing exactly two successes, each having probability (0.5)^4 = 1/16. Thus the total is 6/16 = 3/8.

For a count k, the general point probability is C(n,k) × p^k × (1−p)^(n−k). B sums these point probabilities when T2 is supplied. It does not return a density: these are actual probabilities attached to discrete counts.

The vendor’s dice example, =B(10;1/6;2), independently evaluates to approximately 0.2907100492, which explains its rounded 29% presentation. The derivation is 45 × (1/6)^2 × (5/6)^8. This is a reference calculation, not an authored application result.

Suppose the acceptable count is from one through three successes in the four-trial example. Use =B(4;0.5;1;3) to include all three outcomes. Their numerators are 4, 6 and 4 over the common denominator 16, giving 14/16 = 0.875.

The complementary probability of falling outside that band is 0.125, covering zero or four successes. This is a probability for the stated model, not a guarantee about the next run. For “at most k,” supply an interval starting at zero. For “at least k,” end the interval at Trials. Do not accidentally exclude the boundary outcome by changing an inclusive bound by one.

• =B(4.9;0.5;2.8) follows the inspected flooring rule and predicts 0.375, because the evaluated counts become 4 and 2. Prefer writing those integers directly.
• At SP = 0, all probability lies at zero successes. =B(4;0;0;2) therefore gives 1.
• At SP = 1, all probability lies at four successes. =B(4;1;1;3) gives 0.
• A reversed interval such as =B(4;0.5;3;1) or a probability above 1 follows internal IllegalArgument. Native UI error spelling is unverified.
• Extremely large counts or extreme probabilities can challenge numerical precision. The small exact controls here do not certify every tail calculation.

The ScB implementation separately handles point and interval forms and the degenerate probabilities 0 and 1.

BINOM.DIST orders its arguments as success count, trials, probability and cumulative flag. B instead begins with trials and probability, and its fourth argument is an upper success-count bound. Replacing only the function name would change the meaning of the expression. In particular, B’s fourth argument is not a TRUE/FALSE cumulative switch.

The pinned source’s English ODFF storage/load name table maps BINOM.DIST.RANGE to the same ocB opcode that the ordinary English function table names B. This explains the related name when inspecting formula-format definitions; it is not a separate probability calculation. See the exact ODFF mapping and ordinary B mapping.

The worked formulas use B, the documented function spelling. This source mapping does not establish that typing BINOM.DIST.RANGE in every UI mode is accepted, or that a particular saved file will round-trip unchanged. Those application and export behaviors were not tested.

This guide covers the new Collabora Office desktop for Linux, using the Flathub source tag coda-26.04.4.3-1 and commit 81339d176148d0d5c81ff05d82540f58f8aaa117. The official desktop release notes and Linux package manifest identify that product/build. The package manifest is a dated observation from October 18, 2026, rather than an installed-binary check.

The 26.04 function help and exact evaluator source were inspected on October 18, 2026. Expected examples were independently calculated; no Collabora application was run. Expected scalar results were derived from the documented contracts, inspected source and independent calculations; native output formatting and error localization have not been tested. Classic, Online/CODE, other operating systems and file-format round trips require their own checks.

These are the documented legacy contracts. A similar dotted name does not establish identical argument order, defaults or boundary behavior. The first Collabora release introducing this function is not established by the reviewed sources. No cited retirement or deprecation notice was found; “legacy” here describes the function contract, not a claim that the function has been removed. File-format round trips require separate verification.

• BINOM.DIST: compare the different argument order and cumulative flag
• FACT: understand factorial-based combination counts