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

GMEAN

 

Syntax: @GMEAN(argumentlist)

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

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

displaymath16147

Examples:

@GMEAN(56, 49, 99) = 64.76491

@GMEAN(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


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

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999