Site icon Sheet Natives

How to Use MULTINOMIAL in Google Sheets in 2020?

MULTINOMIALReturns the factorial of the sum of values divided by the product of the values’ factorials.

Sample Usage




MULTINOMIAL(value1, [value2, …])

value1 – The first value or range to consider.

value2, … – Additional values or ranges to consider.


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.


Exit mobile version