Working with Operators
Operators are used to compare or equate values and for mathematic calculations. The following table lists the primary operators used in formulas.
Operator |
Operator Usage or Description |
---|---|
- |
Used in subtraction or to represent a negative number |
! |
Represents a logical NOT |
!= |
Represents not equal |
& |
Represents a logical AND |
* |
Used in multiplication |
/ |
Used in division |
: |
Used to separate a list of values |
:= |
Used to assign a value to a variable |
| |
Represents a logical OR |
+ |
Used in addition or to represent a positive number |
< |
Represents less than |
<= |
Represents less than or equal to |
<> |
Represents not equal |
= |
Represents equal |
=! |
Represents not equal |
> |
Represents greater than |
>< |
Represents not equal |
>= |
Represents greater than or equal to |