﻿ MULTINOMIAL | Spread.NET 16 Formula Reference
Formula Functions / Functions M to Q / MULTINOMIAL
In This Topic
MULTINOMIAL
In This Topic

This function calculates the ratio of the factorial of a sum of values to the product of factorials.

#### Syntax

MULTINOMIAL(value1,value2,...)

MULTINOMIAL(array)

MULTINOMIAL(array1,array2,...)

#### Arguments

The arguments are the values to calculate in the multinomial. Each argument can be a double-precision floating point value, an integer value, or an array of these. Up to 255 arguments may be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.

#### Remarks

If an array or reference argument contains text, logical values, or empty cells, the function ignores those values; however, the function includes in calculations cells with the value zero.

#### Data Types

Accepts numeric data for all arguments. Returns numeric data.

#### Examples

MULTINOMIAL(D5,D6,D7,D8)

MULTINOMIAL(R5C4,R6C4,R7C4,R8C4)

MULTINOMIAL(1,2,3) gives the result 60

#### Version Available

This function is available in product version 1.0 or later.