Operators

The following Boolean operators can be used in an expression.
The syntax is operand1 operator operand2 or operator operand.

&&

logical and (valid for two Boolean operands)

||

logical or (valid for two Boolean operands)

!

logical not (valid for one Boolean operand)

The following arithmetic operators can be used in an expression.
The syntax is operand1 operator operand2 or operator operand.

+

add (valid for two numeric operands)

subtract (valid for one or two numeric operands)

*

multiply (valid for two numeric operands)

/

divide (valid for two numeric operands)

%

remainder (valid for two numeric operands)

The following equality or inequality operators can be used in an expression.
The syntax is operand1 operator operand2.

==

equal to (valid for two numeric, Boolean, or text operands)

!=

not equal to (valid for two numeric, Boolean, or text operands)

<

less than (valid for two numeric operands)

>

greater than (valid for two numeric operands)

<=

less than or equal to (valid for two numeric operands)

>=

greater than or equal to (valid for two numeric operands)