MULTINOMIAL in Apple Numbers: Arrangements and Group Counts

Suppose six distinguishable positions must be filled with one item of type A, two identical items of type B and three identical items of type C. The number of distinct arrangements of those group labels is

(1 + 2 + 3)! / (1! × 2! × 3!) = 720 / 12 = 60

In general, for counts n1,n2,…,nk, the mathematical expression is

MULTINOMIAL(n1,...,nk) = (n1 + ... + nk)! / (n1! × ... × nk!)

This is a combinatorial coefficient, not a multinomial probability distribution. If each category has a probability, the coefficient is only one factor in the full probability calculation; you must also multiply by each category probability raised to its count. [A1, C1]

Common uses include sorting distinct arrangements of repeated letters, assigning a known number of observations to categories and calculating multinomial probability mass terms. It is not interchangeable with COMBIN(n,k) unless there are exactly two categories whose counts sum to the same total. [C1]

=MULTINOMIAL(non-neg-num, non-neg-num…)

Apple explicitly notes: if a supplied argument is a decimal, its fractional portion is truncated to an integer. For example, the mathematical expected value for MULTINOMIAL(2.9,1.8,3.5) is therefore the coefficient for (2,1,3), which is 60. This truncation is Apple-documented, although this particular mixed-decimal formula has not been run natively. Do not invent a rounding-to-nearest rule. [A1, C1]

Use separate numerical arguments in the documented syntax. The individual Apple MULTINOMIAL article does not explicitly establish whether every range, array, blank or nested result is accepted in the variadic argument list. The reproducible tutorial uses distinct cell references rather than assuming a multi-cell range works as one argument. [A1]

Make a Numbers table named Arrangements with B1=A count, C1=B count, D1=C count, and E1=Arrangements. Enter the counts below and enter E2’s formula as shown:

Copy/fill the formula down from E2 to E6 so each row uses that row’s references. The 60 and 630630 answers match Apple’s independently published examples; 30, 20 and 1 follow from independent exact factorial arithmetic. No live Apple Numbers output has been produced. [A1, C1]

When formulas and input cells live in different named Numbers tables, references may need the table qualification Arrangements::B2 rather than a spreadsheet-style global worksheet reference. [A3]

For row 3:

=MULTINOMIAL(2,2,1)
5! / (2! × 2! × 1!) = 120 / 4 = 30

For row 4:

=MULTINOMIAL(3,3,0)
6! / (3! × 3! × 0!) = 720 / 36 = 20

Remember 0! = 1. A zero-sized category does not multiply the denominator by zero or make the result zero. A one-category input, such as Apple’s =MULTINOMIAL(2), always produces 1, because the numerator and denominator are both 2!. [A1, C1]

Imagine 5 independent trials, with three possible outcomes A, B and C having probabilities 0.5, 0.3 and 0.2. The probability of exactly two A outcomes, two B outcomes and one C outcome (in any order) is mathematically

number of arrangements × P(A)^2 × P(B)^2 × P(C)^1
= 30 × 0.5² × 0.3² × 0.2
= 0.135

Enter the complete Numbers formula:

=MULTINOMIAL(2,2,1)*0.5^2*0.3^2*0.2

Expected 0.135. The MULTINOMIAL() value is the count of permissible orderings, not the final event probability by itself. This probability example additionally assumes each trial has the same categorical probabilities and that trials are independent. [A1, C1]

For a table, put nonnegative counts in B2:D2 and the matching probabilities in F2:H2, then use

=MULTINOMIAL(B2,C2,D2)*F2^B2*G2^C2*H2^D2

The formula is a derived mathematical application. Apple’s MULTINOMIAL help does not state the stochastic-model assumptions; they come from probability theory. [C1]

The word BANANA has six letters: A occurs three times, N twice, B once. Its number of distinct letter arrangements is

=MULTINOMIAL(3,2,1)

Expected 60, not 6! = 720, because swapping identical A letters or identical N letters does not create a new arrangement. The method generalizes to repeated objects, provided you genuinely want unlabeled identical members within each group. [C1]

For six positions containing four successes and two failures:

=MULTINOMIAL(4,2)

Expected 15 by the mathematical coefficient 6!/(4!2!). That matches the combinatorial meaning of choosing four of six positions, but do not assume all Excel or Sheets error/overflow behavior transfers to Apple Numbers. The Numbers function’s accepted syntax is established independently by Apple’s help. [A1, C1]

Apple’s explicit truncation rule is easy to miss:

=MULTINOMIAL(2.9,1.8,3.5)

The mathematical expected answer after truncation is 60, not the value for rounded counts (3,2,4). In data-entry forms, truncation can hide mistakenly entered fractional counts. For a research or finance model, validate inputs as whole numbers before relying on the coefficient. [A1, C1]

The arguments must be nonnegative according to Apple. A negative category count is an invalid domain input for the coefficient. The individual help page does not provide the complete exact Numbers error string, maximum total count/overflow threshold, treatment of arbitrary text, or whether each possible form of array reference is accepted. Avoid inventing behavior; very large factorial ratios can grow beyond a spreadsheet’s usable numeric precision. [A1, C1]

Common questions

Can I use just one argument? Yes. Apple explicitly documents =MULTINOMIAL(2) returning 1. [A1]

Is MULTINOMIAL the same as FACT? No. FACT(n) gives one factorial; MULTINOMIAL divides the factorial of the sum of category counts by their factorial product. See Apple’s FACT reference. [A6]

Will it round 2.9 up to 3? No. Apple says decimal arguments are truncated. [A1]

Does zero produce a zero result? No. A zero group contributes 0! = 1; MULTINOMIAL(0,0,0) is mathematically 1. Native handling of all-zero inputs has not been independently executed in Numbers. [C1]

Does Help 15.4 prove MULTINOMIAL is new in 15.4? No. It confirms the documented interface in version 15.4 only. [A1, A4, A5]

• [A1] Apple, MULTINOMIAL — Formulas and Functions Help 15.4: coefficient purpose; required/optional argument types, nonnegative domain, decimal truncation and published examples (2; 1,2,3; 4,5,6).
• [A2] Apple, Functions overview: locale argument separators and function syntax.
• [A3] Apple, Refer to cells in formulas: same-table/cross-table references and anchoring.
• [A4] Apple, Numbers for Mac release notes: release context, not exact function introduction.
• [A5] Apple, Numbers for iPad release notes: release context, not a test of this function on a device.
• [A6] Apple, FACT: separate, related factorial operation.
• [C1] Independent arithmetic, Python 3 exact math.factorial and multiplication; not native Numbers testing. Probability applications are explicitly derived mathematical results.

Native-validation limitation: No Apple Numbers execution or screenshots were performed. Relevant edge cases and locale-specific behavior require testing in the intended application.