Calculates the geometric mean of a dataset.
Sample Usage
GEOMEAN(1,2,3,4,5)
GEOMEAN(A2:A6)
Syntax
GEOMEAN(value1, [value2, ...])
- value1 - The first value or range to consider while calculating the geometric mean value.
- value2, .. - [OPTIONAL] Additional numbers or ranges to consider.
Examples
GEOMEAN(1,2,3,4,5) returns a value of 2.6051.
GEOMEAN(A2:A6) returns the geometric mean of the numbers in cells A2 through A6.