Mathematical Operators

The standard operators such as +, -, *, / are all defined as well as the following operators.

The logical operators can be used with the if function or all alone. For example, the double equal sign (a == b) tests when two values are equal. These comparisons return 1 when true and 0 when false. This is a quick way to compare values in columns.

a^ba raised to the power of b
a == b1 if a is equal to b, 0 otherwise
a != b1 if a is not equal to b
a < b1 if a is strictly less than a
a <= b
a ≤ b
1 if a is less than or equal to b
a > b1 if a is strictly greater than b
a >= b
a ≥ b
1 if a is greater than or equal to b
a && b1 if a and b are non zero
a || b1 if a or b are non zero

Related Articles