Returns the ratio of the factorial of a sum of values to the product of factorials of those values.
구문
MULTINOMIAL(number1, [number2], ...)인수
number1필수
The first value or range of values to include in the calculation.
number2선택
Additional values or ranges to include, up to 255 arguments.
The MULTINOMIAL function calculates the multinomial coefficient, which is used in combinatorics to determine the number of ways to partition a set of objects into groups. It is mathematically equivalent to (sum(number1, number2, ...))! / (number1! * number2! * ...).
=MULTINOMIAL(2, 3, 4)→1260Calculates (2+3+4)! / (2! * 3! * 4!) = 9! / (2 * 6 * 24) = 362880 / 288 = 1260.
Select a cell
Click on the cell where you want to display the multinomial coefficient.
Enter the formula
Type =MULTINOMIAL( followed by your numbers separated by commas, then close the parenthesis.
Excel will truncate the decimal part of the numbers before performing the calculation.