### Function Categories

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 Formulas | 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. |

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 Array FormulasThese 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. |

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