Math
Returns the absolute value of a number.
Syntax
ABS(value)
- value: The number of which to return the absolute value.
Sample Usage
ABS(-2)
ABS(property)
Returns Euler's number, e (~2.718) raised to a power.
Syntax
EXP(exponent)
- exponent: The exponent to raise e to.
Sample Usage
EXP(2)
EXP(property)
Returns a number raised to a power. Equivalent to the "^" operator.
Syntax
POWER(base, exponent) or POW(base, exponent)
- base: The number to raise to the exponent power. If base is negative, exponent must be an integer.
- exponent: The exponent to raise base to.
Sample Usage
POWER(4, 0.5)
POWER(property1, property2)
POWER(2, 5)
Returns the number rounded to the nearest integer.
Syntax
ROUND(value)
- value: The number to round.
Sample Usage
ROUND(1.5)
ROUND(0.5)
Always rounds a number up to the next largest integer.
Syntax
CEIL(value)
- value: The number to round.
Sample Usage
CEIL(1.5)
CEIL(0.5)
Returns the largest integer less than or equal to a given number
Syntax
FLOOR(value)
- value: The number to round.
Sample Usage
FLOOR(1.5)
FLOOR(0.5)
Returns the difference of two numbers. Equivalent to the "-" operator.
Syntax
MINUS(value1, value2)
- value1: The minuend, or number to be subtracted from.
- value2: The subtrahend, or number to subtract from value1.
Sample Usage
MINUS(property1, property2)
MINUS(3, 4)
Returns the result of multiplying a series of numbers together.
Syntax
PRODUCT(factor1, [factor2, ...])
- factor1: The first number or range to calculate for the product.
- factor2, ... - [OPTIONAL]: Additional values to multiply by.
Sample Usage
PRODUCT(numberList)
PRODUCT(1, 2, 3, number, numberList)
Notes
- If only a single number for factor1 is supplied, PRODUCT returns factor1.
- Each factor may be a number or a range. If a list, empty values are ignored.
The ROUND function rounds a number to a certain number of decimal places according to standard rules.
Syntax
ROUND(value, [places])
- value - The value to round to places number of places.
- places - [ OPTIONAL - 0 by default ] - The number of decimal places to which to round. Places may be negative, in which case value is rounded at the specified number of digits to the left of the decimal point.
Sample Usage
ROUND(826.645, 0) // = 827
ROUND(826.645) // = 827
ROUND(826.645, 1) // = 826.6
ROUND(826.645, 2) // = 826.65
ROUND(826.645, 3) // = 826.645
ROUND(826.645, -1) // = 830
ROUND(826.645, -2) // = 800
Notes
- Standard rules indicate that when rounding to a particular place, the next most significant digit (the digit to the right) is considered. If this digit is greater than or equal to 5, the digit is rounded up, otherwise it is rounded down. This occurs irrespective of sign; that is, 'up' and 'down' are in terms of magnitude.
Returns the sum of a series of numbers and/or numbers.
Syntax
SUM(value1, [value2, ...])
- value1: The first number or range to add together.
- value2, ... - [OPTIONAL]: Additional numbers or ranges to add to value1.
Sample Usage
SUM(listOfNumbers)
SUM(1, 2, 3, number, listOfNumbers)
Notes
- If only a single number for value1 is supplied, SUM returns value1.
Returns one number divided by another. Equivalent to the "/" operator.
Syntax
DIVIDE(dividend, divisor)
- dividend: The number to be divided.
- divisor: The number to divide by (cannot equal 0).
Sample Usage
DIVIDE(4, 2)
DIVIDE(number1, number2)
Returns the argument provided as a number.
Syntax
N(value)
- value: The argument to be converted to a number
- If value is TRUE, the result is 1
- If value is FALSE, the result is 0
Sample Usage
N('12') => 12
N(12) => 12
N(TRUE) => 1
N(FALSE) => 0
