Name
HARMEAN
Synopsis
Use HARMEAN to calculate the harmonic mean of a list of positive numeric values. This function is used to find average rates. For example, if you drive from home to the office at 10 mph and return at 20 mph, you can use HARMEAN to calculate your average speed, which is 13.3333 mph.
To Calculate
=HARMEAN(Number1
,Number2
, ...)
There must be at least one Number
argument
specified. All arguments must be positive.
Example
Figure 15-21 illustrates how to use HARMEAN to find the harmonic mean for a list of positive numeric values.
Figure 15-21. Use HARMEAN to find the harmonic mean for a list of numeric values
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.