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
number: The size of each group. Decimals are cut off.
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
9 people into teams of 2, 3 and 4
A B C D E 1 Team 1 Team 2 Team 3 2 2 3 4 1260 In E2:
=MULTINOMIAL(A2:C2)→ 1260
Common mistakes
- Negative sizes. A size below 0 is #NUM!.
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.
- Czech: MULTINOMIAL
- Danish: MULTINOMIAL
- Dutch: MULTINOMIAAL
- Finnish: MULTINOMI
- French: MULTINOMIALE
- German: POLYNOMIAL
- Hungarian: SZORHÁNYFAKT
- Italian: MULTINOMIALE
- Norwegian: MULTINOMINELL
- Polish: WIELOMIAN
- Portuguese (Brazil): MULTINOMIAL
- Portuguese (Portugal): POLINOMIAL
- Russian: МУЛЬТИНОМ
- Spanish: MULTINOMIAL
- Swedish: MULTINOMIAL
- Turkish: ÇOKTERİMLİ
Try MULTINOMIAL in the playground