GEOMEAN

Definition: GEOMEAN is a function that returns the geometric mean of a set of numbers.

Syntax: =GEOMEAN(number1, [number2], …)

Situation: This formula is suitable when you need to find the geometric mean of a set of numbers.

Example: If you have a set of numbers 2, 4, and 8, the geometric mean can be found using the formula =GEOMEAN(2, 4, 8), which returns 4.