Operators are used to set up the calculation method for a formula. You can type the following operators directly into the formula text box.
Operator | Description |
---|---|
+ | Add |
- | Subtract |
* | Multiply |
/ | Divide |
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 |
Operator | Description |
---|---|
AND | And |
OR | Or |
NOT | Not |