Returns the ratio of the factorial of a sum of values to the product of factorials of those values.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
MULTINOMIAL(number1, [number2], ...)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)결과: 1260
Calculates (2+3+4)! / (2! * 3! * 4!) = 9! / (2 * 6 * 24) = 362880 / 288 = 1260.
Excel will truncate the decimal part of the numbers before performing the calculation.