# Documentation/Calc Functions/MULTINOMIAL

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

MULTINOMIAL

## Category:

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 N_{i} 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 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

MULTINOMIAL