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.