Back to Functions

MULTINOMIAL

Returns the factorial of the sum of values divided by the product of the values' factorials.

MathMULTINOMIAL(value1, value2)

The MULTINOMIAL function in Google Sheets returns the factorial of the sum of a set of values, divided by the product of each value's factorial. It's used to calculate multinomial coefficients, which come up often in combinatorics and probability. Dive into our comprehensive guide to master its application.

Parameters

  • value1: The first value.
  • value2: Additional values to include in the calculation.

Step-by-Step Tutorial

  1. Using MULTINOMIAL with two values:
    • Example: =MULTINOMIAL(3, 4)
    • Result: 35

Use Cases and Scenarios

  1. Probability Calculations: Calculate multinomial probabilities in mathematical modeling.
  2. Combinatorial Analysis: Evaluate combinatorial problems involving multinomial coefficients, such as arranging items into groups.

Related Functions

  • FACT: Returns the factorial of a number.
  • COMBIN: Returns the number of ways to choose some number of objects from a pool.
  • PERMUT: Returns the number of ways to choose some number of objects from a pool, taking order into account.

Related Articles

No related articles available for the MULTINOMIAL function.

Newsletter

More MULTINOMIAL examples coming soon.

We are building short, practical updates for Sheets power users.