Excel MULTINOMIAL Function

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

  1. Click on an empty cell (like F5 )
empty cell in excel

2. Click on fx icon (or press shift+F3)

fx icon in excel

3. In the insert function tab you will see all functions

insert function tab in excel

4. Select math and trig category

5. Select MULTINOMIAL function

6. Then select ok

excel MULTINOMIAL function

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

How to use MULTINOMIAL function in excel

Examples of MULTINOMIAL function in Excel

Example 1:

How to use MULTINOMIAL function in excel

You can see examples of MULTINOMIAL function below:

Examples of MULTINOMIAL function in Excel
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)

Errors in MULTINOMIAL function

MULTINOMIAL related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *