This page will list all our functions. Functions are also classified by the following types; Array, Database, Date, Engineering, Filter, Financial, Google, Info, Logical, Lookup, Math, Operator, Parser, Statistical, Text, Web.
| Function Name | Description | Syntax | Type |
|---|---|---|---|
IF | Returns one value if a logical expression is “TRUE” and another if it is “FALSE”. | IF(logical_expression, value_if_true, value_if_false) | Logical |
CONVERT | Converts a numeric value to a different unit of measure. | CONVERT(value, start_unit, end_unit) | Parser |
PRODUCT | Returns the result of multiplying a series of numbers together. | PRODUCT(factor1, [factor2, ...]) | Math |
SUM | Returns the sum or total of cells, ranges, numbers, or a combination of these inputs. | SUM(value1, [value2, ...]) | Math |
ISBLANK | Checks whether the referenced cell is empty. | ISBLANK(value) | Info |