Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments.
MULTINOMIAL (number1, number2, ... number30)
number1 to number30 are up to 30 numbers or ranges of numbers.
This function returns:( number1 + number2 + ... + number30 )! / (number1! * number2! * ...* number30!)
MULTINOMIAL(1, 2)
returns 3, which is (1+2)!/(1!*2!).
MULTINOMIAL(F1:F3)
where F1 to F3 contain 2, 3 and 4 returns 1260.
The multinomial coefficient is a powerful tool for calculating the number of ways to arrange a set of objects into distinct groups. It's an extension of the binomial coefficient, which deals with two groups. The formula for the multinomial coefficient is:
where is the total number of items, and are the sizes of the distinct groups, such that .
Let's consider a scenario: a company is forming a new product development team.
The company has a pool of 10 employees and needs to form a team of 10 with the following roles:
The question is, how many different ways can the company assign these 10 employees to these specific roles?
Here's how we can use the MULTINOMIAL function:
The MULTINOMIAL function takes the sizes of the distinct groups as its arguments. The total number of items (n) is calculated automatically by the function.
The sum of the group sizes is , which equals the total number of employees.
Using the MULTINOMIAL function, the calculation is:
Let's break down the factorials:
Now, substitute these values back into the formula:
This means there are 12,600 different ways to form the new product development team with the specified roles.
Summary Table:
Role | Number of Employees () | ||
|---|---|---|---|
A | B | ||
1 | Software Engineer | 3 | |
2 | Data Scientist | 4 | |
3 | UX Designer | 2 | |
4 | Project Manager | 1 | |
5 | Total | 10 |
Result for MULTINOMIAL(3, 4, 2, 1):
PRODUCT & FEATURES
RESOURCES
Terms | Privacy | Spam Policy
© 2026 Zapof