Use the formula to get geometric mean of the values. Another way to calculate the geometric mean is with logarithms as it is also the average of logarithmic values converted back to base 10. The GEOMEAN function calculates the geometric mean of a set of numbers by returning the nth root of n numbers.
The general formula for the geometric mean of n numbers is the nth root of their product.
We have these values already in column E so we can use them directly in GEOMEAN the function. However each argument can be an array of values or a range of. 2 GEOMETRIC MEAN FOR NEGATIVE AND ZERO VALUES The geometric mean for negative values depends on the following rule. Investment returns over a series of years with some negatives.