This function calculates the ratio of the factorial of a sum of values to the product of factorials.
MULTINOMIAL(value1,value2,...)
MULTINOMIAL(array)
MULTINOMIAL(array1,array2,...)
The arguments are the values to calculate in the multinomial. Each argument can be a double-precision floating point value, an integer value, or an array of these. Up to 255 arguments may be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.
If an array or reference argument contains text, logical values, or empty cells, the function ignores those values; however, the function includes in calculations cells with the value zero.
Accepts numeric data for all arguments. Returns numeric data.
MULTINOMIAL(D5,D6,D7,D8)
MULTINOMIAL(R5C4,R6C4,R7C4,R8C4)
MULTINOMIAL(1,2,3) gives the result 60