Function Categories

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.
Dynamic ArrayThese are used for returning an array of values from a single formula.
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.
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.
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.
Dynamic Array
These are used for returning an array of values from a single formula.
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.
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.

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