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

Категории