Operators are used to set up the calculation method for a formula. You can type the following operators directly into the formula text box.

Arithmetic operators
Operator Description
+ Add
- Subtract
* Multiply
/ Divide

 

Relational operators
Operator Description
GT or > Greater than
LT or < Less than
EQ or = Equal to
GE or >= Greater than or equal
LE or <= Less than or equal
NE or <> Not equal

 

Logical operators
Operator Description
AND And
OR Or
NOT Not