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:
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