 Formula Engine Reference Guide |
|
Back to Class Index
HMEAN(argumentlist)
HMEAN returns the harmonic mean of its arguments. Blank cells and cells containing strings are not counted.
Parameters
argumentlist
Any combination of numbers, cells, or ranges where each value is not equal to 0
Example
HMEAN(F10..F15) = 3.0434783
where F10..F14 = 2, 2, 3, 6, and 7
HMEAN(C1..C5) = Error - HMEAN, operand equal to 0
where C4 = 0