Calculates the multinomial[1] of a number of values.
This is the factorial of the sum of all the values divided by the product of all the factorials of each value.
Syntax:
MULTINOMIAL( list )
Returns the multinomial of all the numeric values in the list.
list may be a range of cells, an array, or a comma-separated list of values (which may contain cell references and also ranges of cells as one or more of its elements).
Formula:
MULTINOMIAL, (x1, …, xn)! = ( i ∑1n xi )! ∕ ( i ∏1n xi! )
where n is the number of values and xi is the i‑th value.
Revisions:
This function was added in Fireworkz 2.00.