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   Formula

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.