GEOMEAN Function in Excel calculates the geometric mean of a supplied set of values.
The geometric mean of a set of values x1, x2, …, xn is calculated by the formula.
Syntax of GEOMEAN Function in Excel:
GEOMEAN (number1, [number2], …)
- Where the number arguments are a set of one or more positive values for which you want to calculate the Geometric mean.
Example of GEOMEAN Function in Excel:
Formula:
- Cells containing Text values, logical values, or no value are ignored by Excel GEOMEAN Function.
- Geometric mean is calculated row wise in above example.
Result:
Note :
#NUM! Error occurs if the supplied numeric values are negative.