Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelGEOMEAN Function in Excel

# GEOMEAN Function in Excel

In this post, you’ll learn about the GEOMEAN Function, its syntax and the way of using the GEOMEAN Function in excel spreadsheet.

## What is GEOMEAN Function?

GEOMEAN Function in excel is a statistical function. GEOMEAN Function calculates the average rate and returns the geometric mean for the given numbers.

#### Syntax

`=GEOMEAN(number 1, [number 2],..)`
##### Arguments;
• = – built-in function.
• GEOMEAN() – function name.
• number 1 – first value.
• number 2 – (optional) second reference value.
• There can be 1 to 255 arguments for calculating the mean.

### Notes:

• Arguments can be numbers, names, array, reference and including zero.
• #NUM! – If the given numeric values are negative.
• #VALUE! – If the supplied values are non-numeric.
• Ignore logical values, text and empty cells.

The equation of GEOMETRIC MEAN is;

## How to use GEOMEAN Function in Excel?

GEOMEAN Function calculates the Geometric mean for the given data.

#### Example:

##### Step 1:

Open the workbook in your Microsoft Excel.

##### Step 2:

Enter the data, in the workbook.

In this example, we have entered some values to calculate GEOMEAN Function.

##### STEP 3:

In the new cell, give the syntax. Start with ‘ =’ for every functions, GEOMEAN to initiate functions name, followed by open parenthesis.

The numbers are from A3:A8.

##### STEP 4:

Press enter to get the values.

You get 68.08111 geometric mean values for the given data.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021