Each function returns either a single value or a range of values (a dataset), depending on the type of function and the arguments supplied. Unless otherwise specified, all functions will return a range if the first argument passed to the function is a range, and all functions will return a value if a value is passed.
| Function Category | Description |
|---|---|
| Math and Trigonometry | Basic math, trigonometric and special math functions |
| Statistics | General statistics functions |
| Distribution | Cumulative Distribution Functions (CDF), Inverse Cumulative Distribution Functions (INV) and Probability Density Functions (PDF) |
| Signal Processing | Fast Fourier Transform functions. |
| Data Manipultion | Sort or replace data, find peaks or correlation |
| Text | Functions for text manipulation |
| Lookup and Reference | Get information about a dataset and look up values in datasets |
| Date and Time | Date and Time functions |
| Logical | Logical function such as if, switch ect |
| Engineering | Functions for conversion between binary number and decimal, as well as units |
| Miscellaneous | Information, missing value, and color/font converter ect |
| Financial | Functions to calculate interest rate |
Refer more functions on the following topics: