AGGREGATE (PQL - xl)
This function calculates the inverse hyperbolic cotangent of the specified numeric value
- Library: PQL \ Spreadsheet \ Math & Trig
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
AGGREGATE(function num, options, ref1, OPTIONAL ref2)
Function Arguments
Name | Description | Type | Optional |
function num | Refers to the number (within the range 1-19) to specify the function that is being used | Number |
|
options | Refers to a particular number that specifies the options to ignore values in the function | Number |
|
ref1 | Specifies the reference to a range of cells | CellRange |
|
ref2 | Specifies the reference to a range of cells | CellRange | Y |
Comments
This function is the same as the Microsoft Excel 'AGGREGATE' function - using the same inputs, logic and outputs.