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 30 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  

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.