Documentation/Calc Functions/MULTINOMIAL

From The Document Foundation Wiki
Jump to: navigation, search
This page contains changes which are not marked for translation.

Other languages:
dansk • ‎English

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:

Multin.png

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:

FACT

ODF standard:

Section 6.16.43, part2

Equivalent Excel functions:

MULTINOMIAL