Returns the factorial of the sum of values divided by the product of the values' factorials.
Sample usage
MULTINOMIAL(1,2,3)
MULTINOMIAL(A2:A9)
Syntax
MULTINOMIAL(value1, [value2, ...])
-
value1– The first value or range to consider. -
value2, ...– Additional values or ranges to consider.
Notes
- Although
MULTINOMIALis specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.
See also
FACTDOUBLE: Returns the 'double factorial' of a number.
FACT: The FACT function returns the factorial of a number.
COMBIN: The COMBIN function returns the number of ways to choose some number of objects from a pool of a given size of objects.