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 | Relational operators | ||
|---|---|---|---|
| + | add | GT or > | greater than |
| - | subtract | LT or < | less than |
| * | multiply | EQ or = | equal to |
| / | divide | GE or >= | greater than or equal |
| LE or <= | less than or equal | ||
| NE or <> | not equal | ||
| Logical operators | |
|---|---|
| AND | and |
| OR | or |
| NOT | not |