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