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 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 |
Related LibreOffice functions:
ODF standard:
Equivalent Excel functions:
MULTINOMIAL