** Syntax**. GEOMEAN(

** Definition**. This function returns the geometric mean of a set of positive numbers. For example, you can use GEOMEAN() to calculate the average growth rate for an interest calculation with variable rates.

The geometric mean is calculated as the *n*-th root from the product of all values where *n* is the number of values.

**Arguments**

. At least one and up to 255 arguments (30 in Excel 2003 and earlier versions) for which you want to calculate the geometric mean. You can also use a single array or a reference to an array instead of arguments separated by commas.*number1*(required) and*number2*(optional)

Arguments can be numbers, names, arrays, or references containing numbers.

If an array or a reference argument ...

Start Free Trial

No credit card required