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.