Function Categories

ArrayThese are used for manipulating vectors and arrays.
CompatibilityThese are still available for backwards compatibility.
CubeThese are used to extract data from Analysis Services cubes.
DatabaseThese are used to analyse, count, add and filter data stored in lists or databases.
Date & TimeThese are used for entering and calculating dates and times.
EngineeringThese are used to handle complex numbers, conversions and measurements.
ExternalThese are used to retrieve data from external sources.
FinancialThese are used for depreciation, accrued interest, annuities, rates of return and future values.
InformationThese are used to identify the contents of cells and determine any errors or blanks.
LambdaThese are used in conjunction with the LAMBDA function.
LogicalThese are used to perform conditional analysis and apply logical conjectures to your data.
Lookup & ReferenceThese are used to locate references and specific values within tables of data.
Maths & TrigonometryThese are used for rounding, ranking, analysing trends and to calculate probabilities and logarithms.
MatrixThese are used for multiplying, transposing and finding the inverse and determinant of arrays.
StatisticalThese are used for standard deviation, distributions, square roots, average, median.
TextThese are used for entering, searching, replacing and manipulating text strings.
WebThese 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 rounding, ranking, analysing trends and to calculate probabilities and logarithms.
Matrix
These are used for multiplying, transposing and finding the inverse and determinant of arrays.
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.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext