Math

abs 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) exp 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) power or pow 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) round returns the number rounded to the nearest integer syntax round(value) value the number to round sample usage round(1 5) round(0 5) ceil 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) floor 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) minus 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) product 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 round 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 sum 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 divide 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) n 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