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

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

 
 Returns the harmonic mean of a data set.

 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=HARMEAN(4,4,4) = 4
    2=HARMEAN(5,5,5) = 5
    3=HARMEAN(3,5,7) = 4
    4=HARMEAN(4,5,6) = 5
    5=HARMEAN(1,5,3,3) = 2.143
    6=HARMEAN(-1,5,3,3) = #NUM!
    7=HARMEAN(-1,"some text",3,3) = #VALUE!
    		 
     Functions - H | Index - H | Office Online 

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