From ZCubes Wiki
Jump to navigation Jump to search

  • Parameters are any set of positive real numbers.
    • HARMEAN(), returns values along an exponential trend.


  • This function gives the Harmonic Mean of a given set of numbers.
  • Harmonic mean is used to calculate the average of a set of numbers.
  • The Harmonic mean is always the lowest mean.
  • Normally
  • Harmonic mean is defined as the reciprocal of the arithmetic mean by the reciprocals of a specified set of numbers.
  • The harmonic mean of a positive real numbers is defined by :


  • In Parameters are any positive real numbers, and here First Parameter is required. From the second parameter are optional.
  • Also arguments can be numbers,names, arrays or references that contain numbers.
  • We can give logical values and text representations of numbers directly.
  • Suppose the arguments contains any text, logical values or empty cells like that values are ignored.
  • This will give the result as error when
1.The arguments with the error values or the referred text couldn't translated in to numbers.
2.Also any data .


  • The syntax is to calculate HARMEAN in ZOS is .
    • Parameters are any set of positive real numbers.
  • For e.g.,HARMEAN(20..30,11..15,45.1..56.1..0.5)
Harmonic Mean


  1. =HARMEAN(1,2,3,4,5) = 2.18978102189781
  2. =HARMEAN(20,25,32,41) = 27.4649361523969
  3. =HARMEAN(0.25,5.4,3.7,10.1,15.2) = 1.0821913906985883
  4. =HARMEAN(3,5,0,2) = #N/A (NUMBER > 0 REQUIRED)
  5. =HARMEAN(1,-2,4) = #N/A (NUMBER > 0 REQUIRED)

Related Videos

Harmonic Mean

See Also


Harmonic mean