MULTINOMIALfunction in Google Sheets calculates the multinomial of a set of numbers. The multinomial of a set of values is the product of factorials of the values divided by the factorial of the sum of the values. This function is useful when working with combinations of sets of values.
- How to use
- Examples of using
MULTINOMIALformula not working?
- Similar formulas to
MULTINOMIAL formula with the syntax shown below, it has 2 required parameters:
- value1 (required):
A set of values to be used in the multinomial calculation. There must be at least 2 values in the set.
- value2 (required):
Additional sets of values to be used in the multinomial calculation. There can be up to 255 additional sets.
ExamplesHere are a few example use cases that explain how to use the
MULTINOMIALformula in Google Sheets.
Calculating the number of possible outcomes
Suppose you have a set of 5 items and want to know how many possible combinations of 2 items can be created from that set. You can use the
MULTINOMIAL function to calculate this by providing the values 3 and 2 as the two sets of values.
Calculating the probability of outcomes
If you know the total number of possible outcomes and the number of desired outcomes, you can use the
MULTINOMIAL function to calculate the probability of getting the desired outcomes. For example, if you have a set of 6 items and want to know the probability of getting 2 specific items when choosing 4 items, you can use the
MULTINOMIAL function to calculate this.
Calculating the number of ways to distribute items
Suppose you have a set of 10 identical items and want to distribute them among 3 people. You can use the
MULTINOMIAL function to calculate the number of ways to distribute the items by providing the values 4, 3, and 3 as the sets of values.
MULTINOMIALnot working? Here are some common mistakes people make when using the
MULTINOMIALGoogle Sheets Formula:
Incorrect number of arguments
The MULTINOMIAL formula requires at least two arguments separated by commas, and can accept up to 255 arguments. Check that the correct number of arguments have been included.
Invalid input type
The MULTINOMIAL formula only works with numeric values. Check that the input values are numbers or can be interpreted as numbers.
Non-integer input value
The MULTINOMIAL formula only works with integer values. If any input value is not an integer, the formula will return an error. Use the ROUND function to convert non-integer values to integers.
Value is negative
The MULTINOMIAL formula only works with positive values. If any input value is negative, the formula will return an error. Check that the input values are positive.
Value is zero
The MULTINOMIAL formula only works with positive values. If any input value is zero, the formula will return an error. Check that the input values are positive.
The following functions are similar to
MULTINOMIAL or are often used with it in a formula:
COMBINfunction calculates the number of combinations for a given number of items. A combination is a way of selecting items from a larger set where order does not matter. This function is commonly used in probability and statistics.
PERMUTfunction returns the number of permutations of a set of objects. A permutation is a way of arranging objects in a specific order. The function takes two arguments:
n, the total number of objects, and
k, the number of objects to arrange. The result is the number of possible permutations. This function is commonly used in combinatorics and probability theory.
RANDARRAYformula is used to create an array of random numbers between 0 and 1. The size of the array is determined by the number of rows and columns specified in the formula.
SUMfunction in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells.
You can learn more about the
MULTINOMIAL Google Sheets function on Google Support.