Navigation:  Formulas and functions > Functions from A to Z > GEOMEAN (geometric mean)

Syntax:

GEOMEAN(Number1 [, Number2, Number3...])

Description:

Returns the geometric mean of the specified numbers.

The geometric mean is the n-th root of the product of the given values (n is the total number of values).

Number1, Number2, etc., are the numbers to be evaluated. All of them have to be greater than zero. The values can be single values, cell ranges or an array.

If this function refers to empty cells, they are ignored. Likewise, cells that contain text strings or logical values, but these can be entered directly into the list of arguments and thus taken into account.

Example:

GEOMEAN(1, 2, 6) returns 2.28943

See also:

HARMEAN, TRIMMEAN, AVERAGE