Operators

Mathematical conventions

The formula language uses standard priority rules between operators. Expressions are evaluated from left to right, respecting parentheses and mathematical precedence rules. You can use parentheses to alter priority or to increase readability.

Binary Operators

A list of the mathematical operators supported by the formula language.

Table 1. Mathematical Operators
Symbol	Definition	Comments
`+`	Addition	When used between numbers, it is mathematical addition. When used between strings, it is the concatenation operator.
`-`	Subtraction or negation	This symbol is used either as a subtraction operator, or in front of an expression to negate the value of the expression.
`*`	Multiplication
`/`	Division
`%`	Modulo	Returns the remainder. For example, 155 % 10=5.
`b&`	Binary AND	Converts numbers to binary and performs an AND operation. For example, `252 b& 63 = 60` `11111100 b& 00111111 = 00111100`
`b\|`	Binary OR	Converts numbers to binary and performs an OR operation. For example, `127 b\| 128 = 255` `01111111 b\| 10000000 = 11111111`

The result of a Boolean operation is an integer value: 0 for False, 1 for True . The value is considered to be False if it is 0, or True for any value other than 0.

Boolean Operators

Table 2. Boolean Operators
Symbol	Definition	Comments
`>`	Greater than
`>=`	Greater than or equal
`<`	Less than
`<=`	Less than or equal
`==`	Equal
`!=`	Not equal
`Like`	Like	It is a string comparison tool. The right argument is a string that can contain wildcard characters. The wildcard characters are as follows. *- Replaces 0 or more characters ? - Replaces one character.
`&&`	Logical AND
`\|\|`	Logical OR