What is MULTINOMIAL Function in Excel?
The MULTINOMIAL function is one of the math functions of Excel.
It Returns the multinomial of a set of numbers.
It also Calculates the ratio of the factorial of a sum of desired numbers to the product of factorials of those numbers.
We can find this function in Math & trig category of insert function Tab.
How to use MULTINOMIAL function in excel
- Click on an empty cell (like F5 )
2. Click on fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select math and trig category
5. Select MULTINOMIAL function
6. Then select ok
7. In the function arguments Tab you will see MULTINOMIAL function
8. Number1: number1,number2,… are 1 to 255 values for which you want the multinomial
9. You will see results in the formula result section
Examples of MULTINOMIAL function in Excel
Example 1:
How to use MULTINOMIAL function in excel
You can see examples of MULTINOMIAL function below:
multinomial(A2,B2,C2) ----->>>>answer is 60
multinomial(A3,B3,C3) ----->>>>answer is 1260
multinomial(A4,B4,C4) ----->>>>answer is 27720
multinomial(A5,B5,C5) ----->>>>answer is 630630
multinomial(A6,B6,C6) ----->>>>answer is 14702688
What is the purpose of MULTINOMIAL function?
It Returns the multinomial of a set of numbers.
What is the Return value of MULTINOMIAL function?
It returns a number.
How many arguments does MULTINOMIAL function have?
This function has just 1 Argument.
The argument of MULTINOMIAL function is number.
Number1: number1,number2,… are 1 to 255 values for which you want the multinomial.
The argument of MULTINOMIAL function is required and not optional.
MULTINOMIAL(number) = number
Which version of excel supports MULTINOMIAL function?
This function is available for all excel versions (2003-2019)
