Formualizer Docs
ReferenceFunctionsMath Functions

MULTINOMIAL

Returns the multinomial coefficient for one or more values.

Summary

Returns the multinomial coefficient for one or more values.

Remarks

  • Each input is truncated toward zero before factorial is applied.
  • Any negative term returns #NUM!.
  • Values that require factorials outside 0..=170 return #NUM!.

Examples

Compute a standard multinomial coefficient
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1260
Non-integers are truncated first
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3

FAQ

Why does MULTINOMIAL return #NUM! for large terms?

If any required factorial falls outside 0..=170, the function returns #NUM!.

Runtime metadata

Category

Math

Signature

MULTINOMIAL(arg1…: Number)

This function accepts a repeating argument pattern (min args: 1).

Arity

min 1, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/math/numeric.rs

MROUND

MROUND: Rounds a number to the nearest multiple.

ODD

Rounds a number away from zero to the nearest odd integer.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does MULTINOMIAL return #NUM! for large terms?Runtime metadata