Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > GEOMEAN
 

GEOMEAN(number1 [,number2] [, …])

 
 Returns the geometric mean of an array of numbers.

 number1The first number.
 number2The second optional number.

 REMARKS
 
  		• The arguments must be either numbers or names, arrays, or references that contain numbers.
     
  		• If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
     
  		• If any data point = 0, then #NUM! is returned.
     
  		• You can have a maximum of 30 arguments.

     EXAMPLES
     
     A
    1=GEOMEAN(4,5,8,7,11,4,3) = 5.477
    2=GEOMEAN(20,30,40) = 28.845
    3=GEOMEAN(1,2,0) = #NUM!
    		 
     Functions - G | Index - G | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top