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