Home : Products : Hach WIMS : Hach WIMS Client : Documentation : Function Reference : Spread Functions : Basic Math Functions : GMEAN
Q12242 - INFO: GMEAN

GMEAN returns the geometric mean of the specified cell range

GMEAN(Cell Range):

Cell Range:  The cell range to anaylze. i.e. (A1:A31)

NOTES:

The GMEAN function only works with numeric cells and ignores zeros (0).  If you need to handle data qualifiers or handle zeros differently use GGM, GGMZ or STATZ

 

EXAMPLES:

GMEAN(C4:C22)

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 5/20/2009 5:45 PM.
Last Modified on 8/17/2018 5:31 PM.
Last Modified by Scott Dorner.
Article has been viewed 2714 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article