Multinomial function in Excel calculates the ratio of the factorial of a sum of supplied values to the product of factorials of those values.
i.e. Multinomial (x1,x2,x3….xn) = (x1+x2+x3….+xn) / x1!x2!x3!….xn!
Syntax of Multinomial Function in Excel
Where number is the Positive number that you want to calculate the Multinomial Function of.
Example of Multinomial Function in Excel
Formula
In Row number 1 values 3,4and 5 are passed as input to multinomial functions so it calculates as follows (3+4+5)! / (3!*4!*5!) so the Resultant value will be 27720.
Similarly multinomial Function calculates for other values too
So the result will be
Result
#NUM! Error occurs if the supplied number argument is negative.