Syntax:
GEOMEAN(list)
Returns the geometric mean of the values in the list. list may be an array, a range of cells, or a comma-separated list of values.
All values in the list must be positive, non-zero numbers.
The equation used is:
(Πi=n xi) 1/n
where xi is each value and n is the number of values.
Example:
GEOMEAN(A1:A15)
returns the geometric mean of the contents of cells in the range A1
to A15
.
Added in 2.00.