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.