What is the syntax for MULTINOMIAL in Excel?

The syntax for MULTINOMIAL is: =MULTINOMIAL(number1, [number2], ...)

How do I use the MULTINOMIAL function?

To use MULTINOMIAL, type =MULTINOMIAL( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What happens if MULTINOMIAL encounters errors?

If MULTINOMIAL encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.

Why is MULTINOMIAL not working in my Excel?

Common issues with MULTINOMIAL include #NUM! if any argument < 0. Start by checking the syntax =MULTINOMIAL(number1, [number2], ...), then verify each referenced cell or range.

Math & Trig

MULTINOMIAL Function in Excel

Q: What is the MULTINOMIAL function in Excel?

Returns the multinomial of a set of numbers.

Syntax

=MULTINOMIAL(number1, [number2], ...)

Arguments

number1 (required): First number
number2 (optional): Additional numbers

Examples

=MULTINOMIAL(2, 3, 4) - Multinomial coefficient - Result: 1260

MULTINOMIAL in reporting workflows

Use absolute references when copying formulas across rows.
For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.

Common errors

#NUM! if any argument < 0

Use cases

Combinatorics
Probability
Statistics

Frequently asked questions

What is the MULTINOMIAL function in Excel? MULTINOMIAL returns the multinomial of a set of numbers. The syntax is =MULTINOMIAL(number1, [number2], ...). Typical use cases include combinatorics, probability, statistics.
How do I use the MULTINOMIAL function? To use MULTINOMIAL, type =MULTINOMIAL( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What happens if MULTINOMIAL encounters errors? If MULTINOMIAL encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.
Why is MULTINOMIAL not working in my Excel? Common issues with MULTINOMIAL include #NUM! if any argument < 0. Start by checking the syntax =MULTINOMIAL(number1, [number2], ...), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.