Math operators

abs(number) Returns the absolute value of the argument. The argument must be numeric.

ceil(number) Returns the smallest integer that is greater than or equal to the argument. The argument must be numeric.

divide(number0, number1) Divides number0 by number1. Both arguments must be numbers and the second one needs to be a non-zero value.

subtract(number0, number1) Subtracts number1 from number0. Both arguments must be numbers.

floor(number) Returns the largest integer that is less than or equal to the argument. The argument must be a number.

avg(number0, number1, ...) Returns the average value of the arguments. Each argument must be numeric. Non-numeric value will be ignored. Avg operator has a second format avg(array). In this format, it only accepts one argument and the argument must be an array with numbers.

multiply(argument, argument, ...) Multiplies the arguments together. Each argument must be numeric. Multiply operator has a second format multiply(array). In this format, it only accepts one argument and the argument must be an array with numbers.

max(argument, argument, ...) Returns the maximum value among the arguments. Each argument must be numeric. Max operator has a second format max(array). In this format, it only accepts one argument and the argument must be an array with numbers.

min(argument, argument, ...) Returns the minimum value among the arguments. Each argument must be a number. Min operator has a second format min(array). In this format, it only accepts one argument and the argument must be an array with numbers.

add(argument, argument, ...) Adds the arguments together and returns the sum value. Each argument must be numeric. Add operator has a second format add(array). In this format, it only accepts one argument and the argument must be an array with numbers.

pow(number, exponent) Raise a number to the exponent and returns the value. Both arguments must be numeric. For example: pow(3,2) = 3^2= 9. 3 is the first number and 2 is the exponent.

round(argument) Rounds the first argument to a whole integer or to a specified decimal place. The argument must be numeric.

sqrt(argument) Returns the square root value of the argument. The argument must be a positive number.

subtract(argument, argument) Subtracts the second argument from the first argument and returns the difference. Both arguments must be numeric.