Function | Usage | Description |
| ABS | ABS(number) | Returns the absolute value of a number, a number without its sign. |
| ACOS | ACOS(number)
| Returns the arccosine of a number, in radians in the range 0 to Pi. The arccosine is the angle whose cosine is Number. |
| ACOSH | ACOSH(number) | Returns the inverse hyberbolic cosine of a number. |
| ASIN | ASIN(number) | Returns the arcsine of a number in radians, in the range -Pi/2 to Pi/2. |
| ASINH | ASINH(number) | Returns the inverse hyperbolic sine of a number. |
| ATAN | ATAN(number) | Returns the arctangent of a number in radians, in the range -Pi/2 to Pi/2. |
| ATANH | ATANH(number) | Returns the inverse hyperbolic tangent of a number |
| AVG | AVG(number1, number2, ...) | Returns the average (arithmetic mean) of its arguments. |
| COMBIN | COMBIN(number, number_chosen) | Returns the number of combinations for a given number of items. |
| CONVERT_OSGB_TO_LAT | CONVERT_OSGB_TO_LAT(osgbX, osgbY) | Converts coordinates from British National Grid (OSGB 36) to the latitude value in WGS 84 (GPS lat/lon)
|
| CONVERT_OSGB_TO_LON | CONVERT_OSGB_TO_LON(osgbX, osgbY) | Converts coordinates from British National Grid (OSGB 36) to the longitude value in WGS 84 (GPS lat/lon) |
| COS | COS(number) | Returns the cosine of an angle. |
| COSH | COSH(number) | Returns the hyperbolic cosine of a number. |
| E | E | Euler's number, e, also called the base of natural logarithms. |
| EXP | EXP(number) | Returns e raised to the power of a given number. |
| FACT | FACT(number) | Returns the factorial of a number, equal to 1*2*3*...*Number. |
| INTCEIL | INTCEIL(number) | Rounds a number up to the nearest integer. |
| INTFLOOR | INTFLOOR(number) | Rounds a number down to the nearest integer. |
| INTROUND | INTROUND(number) | Rounds a number to the nearest integer. |
| LG | LG(number) | Returns the base-2 logarithm of a number. |
| LN | LN(number) | Returns the natural logarithm of a number. |
| LOG10 | LOG10(number) | Returns the base-10 logarithm of a number. |
| LOG | LOG(number, base) | Returns the logarithm of a number to the base you specify. |
| MOD | MOD(number, divisor)
| Returns the remainder after a number is divided by a divisor. |
| PI | PI | Returns the value of Pi, 3.141592653589793, accurate to over 15 digits. |
| POWER | POWER(number, power) | Returns the result of a number raised to a power. |
| RAND | RAND() or RAND(seed) | Returns a random number greater than or equal to 0 and less than 1, evenly distributed. The result changes on every recalculation, unless a seed value (any number) is specified, in which case the number generated is always the same for a given seed. |
| SIGN | SIGN(number) | Returns the sign of a number: 1 if the number is positive, zero if the number is zero, or -1 if the number is negative. |
| SIN | SIN(number) | Returns the sine of an angle. |
| SINH | SINH(number) | Returns the hyperbolic sine of a number. |
| SQRT | SQRT(number) | Returns the square root of a number. |
| SUM | SUM(number1,number2,...) | Adds a list of arguments (e.g. field values) |
| TAN | TAN(number) | Returns the tangent of an angle. |
| TANH | TANH(number) | Returns the hyperbolic tangent of a number. |
| AND | AND(logical1, logical2, ...) | Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE. |
| OR | OR(logical1, logical2, ...) | Checks whether any arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE. |
| CURRENTROW | CURRENTROW() | Evaluates to the row number of the record being evaluated. Numbering starts at 1. |
| RECORDCOUNT | RECORDCOUNT()
| Evaluates to the number of records (rows) in the data. |
| CHOOSE | CHOOSE(index_num, value1, value2, ...) | Chooses a value from a list of values, based on an index number (beginning at 1). |
| DATEDIFF | DATEDIFF(date1, date2, unit) | Establishes the difference between two dates, as a decimal number of a specified unit (optional, default: "days").If date2 is before date1, the result will be negative. E.g. the decimal number of weeks between two dates. Units should be specified as: "years", "months","weeks", "days", "hours", "minutes", "seconds", "milliseconds" |
| DATETOTEXT | DATETOTEXT(date_value, custom_format) | Converts a Date into text, optionally using a custom date format. |
| DATEVALUE | DATEVALUE(text) | Converts a text string that represents a date to a date. |
| EXEC | EXEC(command) | Executes an operating system command, resulting in a text value containing the command's output |
| IF | IF(logical_test, value_if_true,
value_if_false) | Checks whether a condition is met, and returns one value if TRUE,and another value if FALSE |
| LEFT | LEFT(text, num_chars) | Returns the specified number of characters from the start of a text string |
| RIGHT | RIGHT(text, num_chars) | Returns the specified number of characters from the end of a text string |
| LEN | LEN(text) | Returns the number of characters in a text string. |
| LOOKUPCSVCELL | LOOKUPCSVCELL(csv_data,row,column,
has_headers,locale) | Parses and reads CSV data, which may or may not contain a header row. Returns the cell specified (NB. row/column numbers start at zero). This will not perform well for large numbers of calculations or large CSV data. The fifth arguement is optional and you can use it to override the default locale. For an example if the default is italian and you are loading a CSV file with english decimals, add "en" |
| MID | MID(text, start_num, um_chars) | Returns the specified number of characters from the middle of a text string, given a starting position and length |
| NOT | NOT(logical) | Changes FALSE to TRUE, or TRUE to FALSE. |
| NOW | NOW | Returns the current date/time |
| NUM_OF_TOKENS | NUM_OF_TOKENS(text, token_separator)
| Returns the number of tokens (split by a single character such as a comma) in a text value |
| NUMVALUE | NUMVALUE(text) | Converts a text string that represents a number to a number. |
| RANK | RANK(value, fieldName,
ascending, includeNulls) | Returns the rank of a value within the field specified (use a double-quoted field name). This is the value position within the ordered field values. If ascending is not specified, or false, the rank is against a descending order (higher values give higher rank). If the value is NULL, or not present in the list, NULL is returned, unless includeNulls is specified as true, in which case empty cells in the list will be considered. |
| READRES | READRES(file_path_or_url) | Reads the text contents from a file or URL. |
| REPLACE | REPLACE(old_text, start_num,
num_chars, new_text) | Replaces part of a text string with a different text string. |
| REPT | REPT(text, number_times) | Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. |
| SEARCH | SEARCH(find_text, within_text, start_num) | Returns the number of the character at which a specific character or text string is first found, reading from left to right (not case-sensitive). |
| SEARCHREGEX | SEARCHREGEX(reg_expr, within_text, start_num) | Returns the number of the character at which a regular expression is first found, reading from left to right (not case-sensitive). |
| TRIM | TRIM(text) | Removes all spaces from a text string except for single spaces between words |
| PROPER | PROPER(text) | LOWER LOWER(text) Converts all letters in a text string to lowercase. |
| TEXT_LINE_COUNT | TEXT_LINE_COUNT(text) | Returns the number of lines (split by line-break) in a text value |
| TEXTTODATE | TEXTTODATE(text_value, custom_format, lenient) | Converts a Date into text, optionally using a custom date format
(e.g. "dd/MM/yyyy HH:mm:ss", defaults to the current regional format), optionally specifying whether parsing is lenient (true/false, default true). |
| TEXTVALUE | TEXTVALUE(text, pattern) | Converts any value into the text equivalent, optionally using a pattern string. The pattern string refers to the format you want your end results to be in. Click here for information on date and time formats. For numbers please click here. |
| VALUE | VALUE(text) | Converts a text string that represents a number to a number, or date text into a date, where possible, otherwise resulting in a text value. |
