Excel Formulas

Showing page 5 of 21
OFFSET
Lookup

Returns a reference offset from a given reference

AREAS
Lookup

Returns the number of areas in a reference

ADDRESS
Lookup

Creates a cell address as text

INDIRECT
Lookup

Returns a reference specified by a text string

GETPIVOTDATA
Lookup

Returns data stored in a PivotTable

HYPERLINK
Lookup

Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet

INDEX
Lookup

Returns a value or the reference to a value from within a table or range

MATCH
Lookup

Looks up values in a reference or array

RTD
Lookup

Retrieves real-time data from a program that supports COM automation

GROWTH
Statistical

Calculates predicted exponential growth

LINEST
Statistical

Returns the parameters of a linear trend

LOGEST
Statistical

Returns the parameters of an exponential trend

MDETERM
Math

Returns the matrix determinant of an array

MINVERSE
Math

Returns the matrix inverse of an array

MMULT
Math

Returns the matrix product of two arrays

SUMX2MY2
Math

Returns the sum of the difference of squares of corresponding values in two arrays

SUMX2PY2
Math

Returns the sum of the sum of squares of corresponding values in two arrays

SUMXMY2
Math

Returns the sum of squares of differences of corresponding values in two arrays

SERIESSUM
Math

Returns the sum of a power series based on the formula

GESTEP
Math

Tests whether a number is greater than a threshold value

Page 5 of 21