Functions

GEOMEAN

Geometric mean

Try it

When to use it

When should I use GEOMEAN instead of AVERAGE?

Use GEOMEAN when averaging growth rates, ratios, or percentages where the values compound multiplicatively, such as annual investment returns or population growth rates.

Used in

finance · science

Syntax

GEOMEAN(value1,...)

Examples

=GEOMEAN(1,2,3,4,5,6,7,8,9,10) // => 4.5287286881167645
=GEOMEAN(4,9,16) // => 8.320335292207616
=GEOMEAN(2,8) // => 4.000000000000001

GCD

Greatest common divisor

GESTEP

Test whether a number is greater than or equal to a step value