Returns a reference offset from a given reference
Returns the number of areas in a reference
Creates a cell address as text
Returns a reference specified by a text string
Returns data stored in a PivotTable
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
Returns a value or the reference to a value from within a table or range
Looks up values in a reference or array
Retrieves real-time data from a program that supports COM automation
Calculates predicted exponential growth
Returns the parameters of a linear trend
Returns the parameters of an exponential trend
Returns the matrix determinant of an array
Returns the matrix inverse of an array
Returns the matrix product of two arrays
Returns the sum of the difference of squares of corresponding values in two arrays
Returns the sum of the sum of squares of corresponding values in two arrays
Returns the sum of squares of differences of corresponding values in two arrays
Returns the sum of a power series based on the formula
Tests whether a number is greater than a threshold value