HARMEAN Function in Excel calculates the Harmonic mean of a supplied set of values.
The harmonic mean of a set of values x1, x2, …, xn is calculated by the formula
Syntax of HARMEAN Function in Excel:
HARMEAN(number1, [number2], …)
- Where the number arguments are a set of one or more positive values for which you want to calculate the Harmonic mean.
Example of HARMEAN Function in Excel:
Formula:
- Cells containing Text values, logical values, or no value are ignored by Excel HARMEAN Function.
- Harmonic mean is calculated row wise in above example.
Result:
Note :
#NUM! Error occurs if the supplied numeric values are negative.