MULTINOMIAL

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.

Examples

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Main menu
13290008852929726155
true
Search Help Centre
true
true
true
true
true
35
false
false