Author: Oscar Cronquist Article last updated on April 23, 2018

The MULTINOMIAL function calculates the ratio of the factorial of a sum of values to the product of factorials.

Formula in cell D3:


The value is calculated like this:


See mathematical formula below in comments.

Excel Function Syntax

MULTINOMIAL(number1, [number2], ...)


number1 Required. The number for which you want to calculate the multinomial.
[number2] Optional. Up to 254 additional numbers.



  • #VALUE! if argument is nonumeric.
  • #NUM! if argument is less than 0 (zero).

The MULTINOMIAL function has the following mathematical formula: