Expressions Guide - Arithmetic Operators (Welcome to the Guide to Expressions)

You can use the following arithmetic operators in your expressions:

Operator	Symbol	Meaning
Negation	-	Indicates the negative value of an expression.
Power	**	Raises one number to the power of another.
Multiplication	*	Multiplies 2 numbers.
Division	/	Divides 2 numbers and returns a floating point number.
Modulus	Mod	Divides 2 numbers and returns the remainder as the result.
Addition/Concatenation	+	Adds a numeric expression to another numeric expression, adds a numeric expression to a string, adds a number to a date, or concatenates 2 strings. When you add or concatenate 2 strings, a string is returned. The string expression will be evaluated as a string expression. If you add a number to a date, the number is the number of days, and the value is returned as a date.
Subtraction	-	Subtracts a numeric expression from another numeric expression and returns the difference. When dates are used, the subtraction operator subtracts one date from another date and returns the difference in days. If you subtract number from a date, the number is the number of days, and the value is returned as a date.

For each of these operators, an empty expression is treated as zero (number), an empty string ' ', or TRUE (Boolean).

Boolean values are treated as:

String expressions are evaluated as a number except when one string is added to another string.

Further Information

Comparison Operators