Function Categories

Array	These are used for manipulating vectors and arrays.
Compatibility	These are still available for backwards compatibility.
Cube	These are used to extract data from Analysis Services cubes.
Database	These are used to analyse, count, add and filter data stored in lists or databases.
Date & Time	These are used for entering and calculating dates and times.
Engineering	These are used to handle complex numbers, conversions and measurements.
External	These are used to retrieve data from external sources.
Financial	These are used for depreciation, accrued interest, annuities, rates of return and future values.
Information	These are used to identify the contents of cells and determine any errors or blanks.
Lambda	These are used in conjunction with the LAMBDA function.
Logical	These are used to perform conditional analysis and apply logical conjectures to your data.
Lookup & Reference	These are used to locate references and specific values within tables of data.
Maths & Trigonometry	These are used for ranking, analysing trends and to calculate probabilities and logarithms.
Matrix	These are used for multiplying, transposing and finding the inverse and determinant of arrays.
Rounding	These are used for rounding numbers up and down.
Statistical	These are used for standard deviation, distributions, square roots, average, median.
Text	These are used for entering, searching, replacing and manipulating text strings.
Web	These are used for web services, xml and xpath.

Array These are used for manipulating vectors and arrays.
Compatibility These are still available for backwards compatibility.
Cube These are used to extract data from Analysis Services cubes.
Database These are used to analyse, count, add and filter data stored in lists or databases.
Date & Time These are used for entering and calculating dates and times.
Engineering These are used to handle complex numbers, conversions and measurements.
External These are used to retrieve data from external sources.
Financial These are used for depreciation, accrued interest, annuities, rates of return and future values.
Information These are used to identify the contents of cells and determine any errors or blanks.
Lambda These are used in conjunction with the LAMBDA function.
Logical These are used to perform conditional analysis and apply logical conjectures to your data.
Lookup & Reference These are used to locate references and specific values within tables of data.
Maths & Trigonometry These are used for ranking, analysing trends and to calculate probabilities and logarithms.
Matrix These are used for multiplying, transposing and finding the inverse and determinant of arrays.
Rounding These are used for rounding numbers up and down.
Statistical These are used for standard deviation, distributions, square roots, average, median.
Text These are used for entering, searching, replacing and manipulating text strings.
Web These are used for web services, xml and xpath.