Formualizer Docs
ReferenceFunctionsStatistics Functions

GEOMEAN

GEOMEAN: Returns the geometric mean of positive numeric values.

Summary

GEOMEAN is commonly used for rates of change and multiplicative growth comparisons.

Remarks

  • All numeric inputs must be strictly greater than 0.
  • Returns #NUM! if any value is <= 0, or if no numeric values are provided.
  • Non-numeric values in referenced ranges are ignored.

Examples

Geometric mean from scalar values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
8
Geometric mean from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
3

FAQ

When does GEOMEAN return #NUM!?

GEOMEAN returns #NUM! if any numeric value is <= 0 or if no numeric values exist.

Runtime metadata

Category

Statistics

Signature

GEOMEAN(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

GAUSS

GAUSS: Returns the standard normal area between `0` and `z`.

GROWTH

GROWTH: Returns fitted values from an exponential trend model.

On this page

SummaryRemarksExamplesRelated functionsFAQWhen does GEOMEAN return #NUM!?Runtime metadata