harmean() Function

Returns the harmonic mean of the specified number(s), which is the number of terms divided by the sum of the terms' reciprocals.

Syntax

harmean( number, … )

number: (Decimal Array) Numbers over which to calculate the harmonic mean.

Returns

Decimal

Notes

Use this function for the average of rates.

Examples

You can experiment with this function in the test box below.

Test Input

harmean(1,2,3) returns 1.636364

FEEDBACK