Home > Expression Operators > Arithmetic Operators

Arithmetic Operators

Click the name of an operator (name begins with a pound sign) to learn more: 

+, -, *, / add, subtract, multiply, divide
** raise a number to a power (exponentiation)           
   
#ABS Returns the absolute value of a number.
#CEILING Rounds a number up to the next integer.
#DIV Divides two numbers, but returns zero upon division by zero.
#EXP Raises the number e (2.718281828...) to some power.
#FLOOR Rounds a number down to the next integer.
#INT Truncates the fractional part of a number.
#LN Returns the natural log (logarithm base e) of a number.
#LOG Returns the logarithm of a number.
#MAX Returns the maximum (larger) of two numbers.
#MIN Returns the minimum (smaller) of two numbers.
#MOD Divides two numbers and returns the remainder (called the modulus).
#ROUND Rounds a number to the specified number of places, or by default to the nearest integer.
#SIGN Returns the sign (-1, 1, or 0) of a number.
#ZMINUS Subtracts two numbers, with a result not less than 0.