MULTINOMIAL Function in ONLYOFFICE: Counting Arrangements of Repeated Groups

Suppose letters are arranged in a row. If all letters were distinct, the number of orders would be the factorial of the number of letters. If categories repeat, swapping two identical letters does not create a new arrangement. The ONLYOFFICE MULTINOMIAL reference defines MULTINOMIAL as the ratio of factorial of the sum of argument values to the product of individual factorials.

For nonnegative integer category counts a, b, c, …, the mathematical value is:

(a+b+c+...)! / (a! × b! × c! × ...)

Example: the letters AAB have group sizes (2,1). The distinct arrangements are AAB, ABA and BAA: =MULTINOMIAL(2,1) has independently calculated expected value 3. The function counts arrangements of a fixed multiset, not combinations for selecting some objects out of a set.

=MULTINOMIAL(number1, [number2], ...)

Square brackets in ONLYOFFICE help indicate optional arguments; do not literally type the brackets in the formula. The vendor does not specify a default value for missing optional arguments. A single numeric argument is syntactically present, but a first argument’s observed behavior for edge inputs remains untested. Use integer counts in the examples; do not assume fractions or negative numbers are accepted just because the help says numeric.

1. Open a blank sheet and label A1 A count, B1 B count, C1 C count, D1 Formula, E1 Independently expected.
2. Fill rows 2–7 with the following data. For each row, type the formula in D exactly as provided. For the two-category example use only two arguments.
3. Place the independent expected answer in E, and compare it against observed output after native testing. For variable-length groups, a direct literal formula avoids accidentally counting blank cells.

Additional independent test cases: =MULTINOMIAL(2,2,2) expects 90; =MULTINOMIAL(3,3,2) expects 560. A missing third value in the two-argument row is simply omitted from the formula rather than explicitly passed as blank.

Validation labeling: these values were computed using Python standard-library integer arithmetic and represent expected mathematical results. No screenshot, formula execution, locale trial, or native error observation was produced.

The word BALLOON has seven letters with category counts: B=1, A=1, L=2, O=2, N=1. Distinct letter sequences number:

7! / (1! × 1! × 2! × 2! × 1!) = 5040 / 4 = 1260

The worksheet formula is =MULTINOMIAL(1,1,2,2,1), expected 1260. This uses category frequencies, not the numeric Unicode codes for the letters. A useful cross-check is to choose the two L positions from seven, choose two O positions from the five remaining, then place B/A/N in the other three: COMBIN(7,2)×COMBIN(5,2)×FACT(3)=21×10×6=1260. This mathematical identity uses separately documented ONLYOFFICE functions, but the observed workbook result still needs native validation.

Given counts (2,2,1), the total is 5 items, with A repeated twice and B repeated twice. =MULTINOMIAL(2,2,1) has expected 30. By sequential choices of category positions: =COMBIN(5,2)*COMBIN(3,2) also has mathematical expected 10×3=30. =FACT(5) instead predicts 120 labelled arrangements and overcounts the arrangements of repeated letters by 2!×2!=4. Official COMBIN, official FACT.

A zero-count category makes no difference to the mathematical factorial quotient because 0!=1; for instance (0,2,1) has expectation 3. This is a mathematical consequence, not an independently observed vendor edge case.

• Confusing counts with values: arguments are the numbers of objects in each indistinguishable group, not the elements themselves. For AAB enter 2,1 rather than 1,1,2 as individual character codes.
• Treating identical objects as distinct: using FACT(total) overcounts arrangements whenever a group repeats.
• Input domain: the vendor article doesn’t explicitly describe acceptance or rejection of negative or fractional numbers. Use nonnegative integers for modeled group counts and separately test coercions and exact errors.
• Too many arguments: official help documents up to 255 numeric values; keep the calculation within that documented limit; do not assume a range bypasses it.
• Reference blanks and text: exact evaluation of mixed-type ranges/empty cells is unverified; don’t state an error string without a native test.
• Large factorials: the mathematical count may exceed the exact range of floating-point spreadsheet numbers. For compliance work use an independent arbitrary-precision integer and record any rounding.
• Cross-product confusion: PRODUCT multiplies numeric entries; it does not apply the special factorial ratio automatically. Use MULTINOMIAL for the arrangements count.

FACT (factorials), COMBIN (choosing positions), PERMUT (ordered selection without replacement). These links lead to the official vendor references.

• Definition, function category and exact published argument spelling/order: ONLYOFFICE MULTINOMIAL page.
• Function picker and manually typed syntax with commas: official Insert Functions instructions.
• Configurable formula language and region: official Advanced Settings.
• Different version histories: Docs changelog and Desktop changelog. Neither is cited as proof of a first-supported release.
• Numerical expectations and special cases: independent integer mathematics, not vendor runtime verification. Known uncertainty: Vendor short help does not state the full input domain or first-supported version; restrict examples to nonnegative integers and mark coercions, specific native errors and release boundaries untested.

Open an editable worksheet, select the output cell, and enter the formula beginning with =. The official formula entry instructions also support Formula → Function (or the Insert Function dialog) with a name search and argument wizard; manually entered English examples on that page use commas between arguments. Press Enter to calculate. For spreadsheet software and build versions not yet tested, treat the numerical answers below as expected, not observed.

This guide writes English function names and comma-separated arguments, matching the official English entry help (checked 2026-10-13). ONLYOFFICE also lets users change the Formula Language and regional number-format settings via File → Advanced Settings (vendor instructions); do not assume the localized function spelling, argument punctuation, decimal mark, or workbook behavior is identical without checking the installed language configuration. The documented regional choices include separate decimal and thousands separator controls, which are not a license to guess a local formula argument delimiter.

These short vendor function references are not versioned. See the independent ONLYOFFICE Docs changelog and Desktop Editors changelog; neither a first-support version nor identical behavior in all historical web, desktop, mobile or third-party spreadsheet engines has been established by this review. The examples are based on documented syntax and independently computed integer mathematics. **Native ONLYOFFICE web/desktop execution: not performed. Localized testing: not performed. Exact native error strings: not observed. **

Native Desktop/web execution, localized formula parsing, error outcomes and undocumented boundary behavior were not tested. Verify these cases in the target version before relying on them.