1. Home
  2. Functions
  3. Math
  4. MULTINOMIAL

MULTINOMIAL function

Returns the factorial of a sum of values divided by the product of their factorials.

Syntax

=MULTINOMIAL(number1, [number2], ...)

Arguments

ArgumentRequiredDescription
number1RequiredThe first number or range
number2OptionalMore numbers or ranges

How to use MULTINOMIAL

MULTINOMIAL takes 1 required argument and 1 optional argument, and accepts more values in the same pattern. Type =MULTINOMIAL( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.

Examples

Each result below was calculated by the SheetsBat formula engine.

=MULTINOMIAL(2, 3, 4)Result 1260
=MULTINOMIAL(3)Result 1

Every formula, right in your browser

SheetsBat calculates 536 functions, with charts, pivot tables and live collaboration. Free to start.