next up previous contents index
Next: GRAND Up: A. Function Reference Previous: GAMMA   Contents   Index


GMEAN, GEOMEAN

Syntax: GMEAN(argumentlist)
  GEOMEAN(argumentlist)

argumentlist = any combination of numbers, cells, or ranges with each of the values greater than 0

GMEAN returns the geometric mean of its arguments. Blank cells and cells containing strings are not included. The function is given by:

\begin{displaymath}
\sqrt[n]{\prod_{i=1}^N a_i}
\end{displaymath}

GEOMEAN is a synonym for GMEAN.

Examples:

GMEAN(56, 49, 99) = 64.76491

GEOMEAN(F10..F14) = 3.4712517, where F10..F14 = 2, 2, 3, 6, and 7

GMEAN(U7..V15) = Error - GMEAN, operand less than or equal to zero, where U13 = 0

Excel function: GEOMEAN


next up previous contents index
Next: GRAND Up: A. Function Reference Previous: GAMMA   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003