# Documentation/Calc Functions/MULTINOMIAL

Jump to navigation Jump to search
Other languages:
English • ‎dansk

MULTINOMIAL

Mathematical

## Summary:

Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments.

## Syntax:

MULTINOMIAL(Number 1 [; Number 2 [; … [; Number 255]]])

## Returns:

Returns an integer value.

## Arguments:

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.

• If an argument is a non-integer real value, the function uses its floor value, i.e. truncates it to integer.
• If any argument is negative after truncation to an integer, the function returns an error value.

## Additional details:

The formula for MULTINOMIAL is:

where Ni represents Number i and FACT is the factorial function.

## Examples:

Formula Description Returns
=MULTINOMIAL(5;6;7) function calculates (5+6+7)! / (5!*6!*7!) 14702688
=MULTINOMIAL(5.5;6;7) floor value of 5.5 is considered further function calculates (5+6+7)! / (5!*6!*7!) 14702688
=MULTINOMIAL(0;6;7) FACT(0) is defined 1 further function calculates (0+6+7)! / (0!*6!*7!) 1716
=MULTINOMIAL(F11:H11) where F11 to H11 contain the values 2, 3 and 4 function calculates (2+3+4)! / (2!*3!*4!) 1260

MULTINOMIAL