GEOMEAN

Returns the geometric mean of the arguments.

Syntax:

GEOMEAN(number1, number2, ... number30)

number1 to number30 are up to 30 numbers or ranges containing numbers. Numbers must not be zero.

The geometric mean of $a_1,a_2,\dots a_n$ is defined as $(a_1\cdot a_2\cdot \dots \cdot a_n{)}^{1/n}$.

Example:

GEOMEAN(1, 2, 4)

returns 2, calculated as $(1\ast 2\ast 4{)}^{1/3}$.