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
MULTINOMIAL
is 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.