|
<< Click to Display Table of Contents >> HARMEAN (harmonic mean) |
Syntax:
HARMEAN(Number1 [, Number2, Number3 ...])
Description:
This returns the harmonic mean of the given numbers.
This is defined as the reciprocal value of the arithmetic mean of the reciprocal values of the individual values.
All given values Number1, Number2, etc., have to be greater than zero. The values can be single values, cell ranges or an array.
If this function refers to empty cells, they are ignored. Likewise, cells that contain text strings or logical values, but these can be entered directly into the list of arguments and thus taken into account.
Example:
HARMEAN(1, 2, 6) returns 1.8
See also: