HARMEAN Function

Basic Description

The Excel HARMEAN function calculates the harmonic mean of a supplied set of values.

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

Where the number arguments are 1 or more positive numeric values, for which you want to calculate the harmonic mean. These arguments can be supplied to the function either directly, as the results of other formulas, or as references to cells containing numeric values. In Excel 2003 the function can accept up to 30 number arguments, but in Excel 2007 and Excel 2010 the function can accept up to 255 numbers.

 

Example of Excel Harmean Function

Harmean Function Example

Cell B1 of the spreadsheet on the right shows a simple example of the Excel Harmean Function, used to calculate the harmonic mean of the values in cells A1-A5. In this example, the Harmean function returns the value 1.229508197.

 

Harmean Function Errors

If you get an error from the Excel Harmean function this is likely to be one of the following :

#NUM! Occurs if any of the supplied values are negative
#VALUE! Occurs if any of the supplied values cannot be interpreted as numeric values

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment