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.