BINOM.DIST in ONLYOFFICE: Exact Counts and Cumulative Probability
Calculate binomial point and cumulative probabilities, rebuild the answer from combinations, and compare BINOMDIST with interval and inverse functions.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =BINOM.DIST(2,4,0.5,FALSE) has the mathematical target 0.375; changing the last argument to TRUE gives 0.6875. The first asks for exactly two successes, the second for at most two. This guide also covers BINOMDIST.
Syntax and the model you are choosing
=BINOM.DIST(number_s, trials, probability_s, cumulative)
=BINOMDIST(number_s, trials, probability_s, cumulative)
The four arguments are success count k, trial count n, per-trial success probability p, and a logical mode. FALSE selects a probability mass, TRUE a cumulative probability. Counts should be whole numbers with 0≤k≤n, and 0≤p≤1. Use explicit TRUE/FALSE rather than relying on numeric or text coercion.
A binomial model assumes a fixed trial count, two outcomes per trial, independent trials and the same probability each time. For example, four independently sampled parcels each have a modeled 50% chance of meeting a chosen criterion. If trials influence one another, or sampling without replacement changes the chance, a binomial result can be mathematically correct but inappropriate for the situation.
The official modern reference and legacy reference document both names. In the pinned implementation, BINOM.DIST inherits BINOMDIST’s calculation without overriding it. This is source evidence for teaching the spellings together, not a claim that every importing application handles them identically.
Build a reusable probability sheet
On a blank sheet named BinomialModel, enter labels and values:
| Cell | Meaning | Value |
|---|---|---|
| B2 | Trials n | 4 |
| B3 | Success probability p | 0.5 |
| B4 | Success count k | 2 |
Place formulas outside B2:B4:
| Cell | Formula | Independent target |
|---|---|---|
| E2 | =BINOM.DIST(B4,B2,B3,FALSE) |
0.375 |
| E3 | =BINOM.DIST(B4,B2,B3,TRUE) |
0.6875 |
| E4 | =BINOMDIST(B4,B2,B3,FALSE) |
0.375 |
Format E2:E4 as percentages if useful: 37.5%, 68.75% and 37.5%. Formatting does not change the stored probability. Do not enter 50 for p when you mean 50%; use 0.5 or a genuine 50% numeric value.
Independently rebuild the distribution
Enter k=0,1,2,3,4 in A8:A12. In B8 enter =COMBIN($B$2,A8)*$B$3^A8*(1-$B$3)^($B$2-A8) and fill down to B12. In C8 enter =SUM($B$8:B8) and fill down.
| k | Point probability | Cumulative probability |
|---|---|---|
| 0 | 0.0625 | 0.0625 |
| 1 | 0.25 | 0.3125 |
| 2 | 0.375 | 0.6875 |
| 3 | 0.25 | 0.9375 |
| 4 | 0.0625 | 1 |
The combinations are 1,4,6,4,1; every four-trial sequence has probability 1/16. Thus exactly two successes has probability 6/16, while at most two has probability (1+4+6)/16. =SUM(B8:B12) should have target 1. This table is an independent mathematical check, not output captured from ONLYOFFICE.
Advanced: translate words into the correct tail
Using the same model:
| Question | Formula | Target |
|---|---|---|
| At least three successes | =1-BINOM.DIST(2,4,0.5,TRUE) |
0.3125 |
| More than two successes | =1-BINOM.DIST(2,4,0.5,TRUE) |
0.3125 |
| At least two successes | =1-BINOM.DIST(1,4,0.5,TRUE) |
0.6875 |
| Between one and three, inclusive | =BINOM.DIST(3,4,0.5,TRUE)-BINOM.DIST(0,4,0.5,TRUE) |
0.875 |
The lower subtraction is F(a−1), not F(a). Using F(1) in the last row would accidentally exclude exactly one success. For extremely small tails, subtracting a value near 1 can lose precision; the simple cases here deliberately avoid that numerical regime. No large-n accuracy guarantee is established by these examples.
Errors, fractional counts and compatibility
The inspected calculation rejects negative k, k>n and p outside 0..1 with its numeric-domain error, corresponding to #NUM!. For example, =BINOM.DIST(5,4,0.5,FALSE) is source-predicted to fail. Keep count cells numeric; quoted numeric strings and arrays are outside this guide’s verified input contract.
The source checks the original count values and then uses integer parsing for the actual binomial computation. That is not a reason to submit fractional counts: validation occurs before truncation, and a fractional boundary can behave differently from rounding the inputs first. Store whole-number counts and check them before calculation.
Both names share the inspected calculation, but that does not imply full cross-product compatibility or availability in older clients. BINOM.DIST.RANGE exposes inclusive interval bounds directly. BINOM.INV instead returns the smallest count reaching a chosen cumulative probability. COMBIN supports the independent counting check.
References checked October 18, 2026
- ONLYOFFICE BINOM.DIST and BINOMDIST: worksheet syntax and purpose.
- Official tagged SDKJS calculation and inheritance: source-level domain checks and alias relationship.
Availability, version scope and verification
This function is currently documented in ONLYOFFICE’s rolling Spreadsheet Editor help. Its original introduction version/date and final supported-version endpoint are not established here. A legacy spelling does not by itself mean that a function is deprecated or retired.
The implementation evidence is official SDKJS tag v10.0.0.169, pinned to commit 3679e0375a758d7dc59d31337a45461be3525ed8. That identifies the inspected source revision, not proof of identical behavior in every Docs server, Desktop Editors build, mobile client or exported workbook. Sources were checked on October 18, 2026.
These examples were not tested in the application. Numerical answers in this guide are independently calculated mathematical targets; implementation-specific cases are explicitly source-predicted. No ONLYOFFICE calculation engine was executed for these examples. No native screenshot, recalculated workbook or successful GUI workflow is claimed. Formulas use English names and comma separators; a localized installation may require different separators or translated names.