September 2011
Beginner
140 pages
3h 40m
English
The HARMEAN function returns the harmonic mean of up to 30 given arguments separated with the semicolon sign (;). Each such argument may be a range of cells. For example:
=HARMEAN(12.55; 10.93; 11.78; 12.00; 11.54; 12.67; 23.56; 45.21; 0.67)
returns 4.36.
Figure 7-3. Sample result of the HARMEAN function
Read now
Unlock full access