Function Reference

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: