next up previous contents index
Next: HOUR Up: A Function Reference Previous: HLOOKUP

HMEAN

 

Syntax: @HMEAN(argumentlist)

argumentlist = any combination of numbers, cells, or ranges where each value is not equal to 0

@HMEAN returns the harmonic mean of its arguments. Blank cells and cells containing strings are not counted.

The function is given by:

displaymath16153

Examples:

@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


next up previous contents index
Next: HOUR Up: A Function Reference Previous: HLOOKUP

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999