How to use the Excel MULTINOMIAL function

Many people find it difficult to solve multinomial problems or equations. It’s really hard to do manually especially when you are working with large multinomial factorial equations in mathematics. Luckily, Microsoft Excel features a useful function to address that problem. This Excel function is called the MULTINOMIAL function. To begin with, try to read this fundamental description of the MULTINOMIAL function to get a basic knowledge about this Excel function.

i.e.  Multinomial

Syntax: Multinomial(number1, [number2], …)

The MULTINOMIAL function syntax has the following arguments:

  • Number1, number2, … :  Number 1 is required, subsequent numbers are optional. 1 to 255 values for which you want the multinomial.

Example: Let’s look at some Excel MULTINOMIAL function examples and explore how to use the MULTINOMIAL function as a worksheet function in Microsoft Excel:

Syntax:  =MULTINOMIAL(A2,B2,C2)


Based on the Excel spreadsheet above, the following MULTINOMIAL examples would return:

Syntax: =MULTINOMIAL(A3,B3,C3)
Result: 27720

Syntax: =MULTINOMIAL(A4,B4,C4)
Result: 504

Syntax: =MULTINOMIAL(A5,B5,C5)
Result: 252

Result: 7

Result: 21

Result: 1716

Result: 35

Syntax: =MULTINOMIAL(A10,B10)
Result: 792


  • The multinomial is
  • If any argument is nonnumeric, MULTINOMIAL returns the #VALUE! error value.
  • If any argument is less than zero, MULTINOMIAL returns the #NUM! error value.
  • If any of the supplied values are decimals, these are truncated to integers.
  • In current versions of Excel (Excel 2007 and later), you can supply up to 255 number arguments to the Multinomial function, but in Excel 2003, the Multinomial function can only accept up to 29 arguments.

Add a Comment

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