call-for-papers

The following is a list of math and statistical functions.

Function Description

ABS Returns the absolute value of a number.

COUNT Counts the number of valid objects in a series.

COUNTABS Counts the number of objects, valid and invalid, in a series.

FROMBASETEN Converts an integer to a text item that can be interpreted as a number, using positional notation of the base specified.

INT Returns the integer portion of a number.

MAX Returns the maximum value from a series of number, date, time or text values.

MIN Returns the minimum value from a series of number, date, time or text values.

MOD Returns the modulus after a number is divided by an integer.

ROUND Rounds a number to a specified number of decimal places or to a whole number if no decimal places are specified.

SQRT Returns the square root of a number.

SUM Calculates the sum of a series of numbers.

TOBASETEN Converts a text item that can be interpreted as a number, using positional notation of the base specified, to a base 10 number.

TRUNCATE Truncates a number to a specified number of decimal places, or, if the decimal places are not specified, truncates it to an integer.