HARMEAN Function Explained
The HARMEAN Function in Microsoft Excel calculates the harmonic mean of a set of numbers. The harmonic mean is the reciprocal of the arithmetic mean of the reciprocals of the given numbers. It is used to calculate the average of rates and is often used in finance. The syntax for the HARMEAN Function is HARMEAN(number1, [number2], ...), where number1 is a required argument and number2 is an optional argument.
HARMEAN Function Syntax
HARMEAN(number1, [number2], ...)
- number1: The first number or range of numbers for which you want to calculate the harmonic mean.
- number2: (optional) Additional numbers or ranges of numbers for which you want to calculate the harmonic mean.