MULTINOMIAL


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

Syntax:

MULTINOMIAL (number1, number2, ... number30)

number1 to number30 are up to 30 numbers or ranges of numbers.
This function returns:( number1 + number2 + ... + number30 )! / (number1! * number2! * ...* number30!)

Example:

MULTINOMIAL(1, 2)
returns 3, which is (1+2)!/(1!*2!).
MULTINOMIAL(F1:F3)
where F1 to F3 contain 2, 3 and 4 returns 1260.






 
Created with Zapof