HARMEAN (PQL - xl)

This function returns the harmonic mean of a data set

  • Library: PQL \ Spreadsheet \ Statistical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

HARMEAN(number1, number2)

Function Arguments

Name

Description

Type

Optional

number1

Specify a set of numeric values. You can also use a single array or a reference to an array instead of arguments separated by commas. If an array or reference argument contains text, logical values, or empty cells, the function ignores those values

StringOrNumber

number2

Specify a set of numeric values. You can also use a single array or a reference to an array instead of arguments separated by commas. If an array or reference argument contains text, logical values, or empty cells, the function ignores those values

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'HARMEAN' function - using the same inputs, logic and outputs.