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

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

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

* 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 -
* For the Microsoft documentation refer to
* For the Google documentation refer to

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!

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top