# MULTINOMIAL

MULTINOMIAL(number1 [,number2] [..])

Returns the number of permutations for a given number of items (with duplicates).

 number1 The first number. number2 (Optional) The second number.

 REMARKS
 * This is called the Multinomial Coefficient.* There is no Excel function for a multinomial distribution.* The multinomial coefficient is an extension of the Binomial Coefficient.* The multinomial coefficient is used to find the "correct" number of permutations when you have duplicate values.* The multinomial is the ratio of the factorial of a sum of values to the product of the factorials.* If any argument is less than one, then #NUM! is returned.* If any argument is not numeric, then #VALUE! is returned.* You can have a maximum of 255 arguments.* You can use the COMBIN function to return the number of combinations for a given number of items (without repetition).* You can use the FACT function to return the factorial of a positive whole number.* link - statisticshowto.com/multinomial-coefficient* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =MULTINOMIAL(2, 3, 4) = 1260 2 =MULTINOMIAL(1, 2, 3) = 60 3 =MULTINOMIAL(3, 2, 1) = 60 4 =MULTINOMIAL("3", "2", 1) = 60 5 =FACT(3+2+1)/(FACT(3)*FACT(2), FACT(1)) = 60 6 =FACT(SUM(3, 2, 1))/(FACT(3), FACT(2)*FACT(1)) = 60 7 =MULTINOMIAL(3, -2, 1) = #NUM! 8 =MULTINOMIAL(3, 2, "some text") = #VALUE!