MULTINOMIAL Function in Excel: Syntax, Examples and Free Practice
MULTINOMIAL is an Excel Math & Trig function. Returns the ratio of the factorial of a sum to the product of factorials.
MULTINOMIAL syntax
Arguments
number1: The first number or rangenumber2: An additional number or range (optional)
When to use MULTINOMIAL
MULTINOMIAL is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice MULTINOMIAL online, free
Open the live Excel-style spreadsheet and try MULTINOMIAL yourself. No Excel install or sign-up needed to start.
Practice MULTINOMIAL now →More Math & Trig functions
Frequently asked questions
What does the MULTINOMIAL function do in Excel?
Returns the ratio of the factorial of a sum to the product of factorials.
What is the syntax of MULTINOMIAL in Excel?
The syntax is =MULTINOMIAL(number1, [number2], ...). number1: The first number or range; number2: An additional number or range (optional).
Where can I practice MULTINOMIAL online for free?
Open the free live spreadsheet on Cellgrids and try MULTINOMIAL yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts