Formualizer Docs
ReferenceFunctionsStatistics Functions

PRODUCT

Multiplies all numeric arguments and returns their product.

Summary

PRODUCT is useful for chained growth factors, scaling ratios, and compound multipliers.

Remarks

  • Non-numeric values in referenced ranges are ignored.
  • Returns 0 when no numeric values are found.
  • Direct scalar arguments still attempt numeric coercion.

Examples

Product of scalar values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
24
Product from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
50

FAQ

Why does PRODUCT return 0 when no numeric inputs are found?

This implementation returns 0 for an empty numeric set after filtering.

Runtime metadata

Category

Statistics

Signature

PRODUCT(arg1…: Number (Range))

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

Arity

min 1, max variadic

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

PUREREDUCTIONNUMERIC_ONLY

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

POISSON.DIST

POISSON.DIST: Returns the Poisson probability for event count `x` at average rate `mean`.

QUARTILE.EXC

QUARTILE.EXC: Returns an exclusive quartile value for a data set.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does PRODUCT return 0 when no numeric inputs are found?Runtime metadata