[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

HARMEAN

Syntax:

HARMEAN ( argument-list )

Description: Computes the harmonic mean of a data set.

Mathematical Formula:

Arguments:

Name

Type

Description

argument-list

logical, text, number, name, array, or reference to number.

The arguments in argument-list designate the values to be averaged. Argument values can be numbers, or names, arrays, or references that contain numbers. Logical values and text representations of numbers entered directly into the list of arguments are included. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included.

 

Return Type and Value: number – The harmonic mean of a data set.

However, if the value of any data point ≤ 0, #NUM! is returned.

[Example:

HARMEAN(4.6,5.8,8.3,7) results in 6.124222
HARMMEAN(10.5,{5.3,2.9},"12") results in 5.617360

end example]