WorksheetFunction.MultiNomial Method (Excel)
Returns the ratio of the factorial of a sum of values to the product of factorials.
Syntax
expression .MultiNomial(Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7, Arg8, Arg9, Arg10, Arg11, Arg12, Arg13, Arg14, Arg15, Arg16, Arg17, Arg18, Arg19, Arg20, Arg21, Arg22, Arg23, Arg24, Arg25, Arg26, Arg27, Arg28, Arg29, Arg30)
expression A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 - Arg30 |
Required |
Variant |
Number1,number2, ... - 1 to 29 values for which you want the multinomial. |
Return Value
Double
Remarks
If any argument is nonnumeric, MULTINOMIAL returns the #VALUE! error value.
If any argument is less than zero, MULTINOMIAL returns the #NUM! error value.
The multinomial is:
.gif "Ff838580.awfmlnom_ZA06051208(en-us,office.14).gif")