Documentation/How Tos/Calc: HARMEAN function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 08:40, 17 July 2018 by Sancho (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


HARMEAN

Returns the harmonic mean of the arguments.

Syntax:

HARMEAN(number1; number2; ... number30)

number1 to number30 are up to 30 numbers or ranges containing numbers. Numbers must not be zero.
The harmonic mean of a1, a2, ... an is defined as
Calc harmean formula.png.

Example:

HARMEAN(2; 4; 4)

returns 3, calculated as 3/(1/2 + 1/4 + 1/4).

Issues:

  • Calc assumes that logical values are 1 (TRUE) and 0 (FALSE). Excel ignores logical values.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_HARMEAN_function&oldid=243497"
Views
Personal tools
Navigation
Print/export
Tools