Excel functions / Math

MULTINOMIAL function

The number of ways to split a group into smaller groups of the given sizes: the factorial of the total, divided by the factorial of each size.

Syntax

=MULTINOMIAL(number1, [number2], …)

Arguments

When to use it

MULTINOMIAL gives how many ways a group can be split into smaller groups of given sizes: the factorial of the total divided by the factorial of each size.

Examples

  1. 9 people into teams of 2, 3 and 4

    ABCDE
    1Team 1Team 2Team 3
    22341260

    In E2: =MULTINOMIAL(A2:C2) → 1260

    Try this example

Common mistakes

MULTINOMIAL in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try MULTINOMIAL in the playground

Related functions