operators.md

title
Operators

All operators have analogs among functions. In each case you can use the most appropriate option.

Template of using binary operators: <Operand A> <operator> <Operand B>

Template of using unary operators: <operator> <Operand B>

As operands of the operators, you can pass numeric scalars, numeric functions, math constants, boolean scalars, boolean functions, or a column name. To pass a column cell, you can use the syntax ${columnName}. Other ways to use operands: true , false, PI, E etc.

Operators and functions can organize expressions as complex as you like. You can also use parentheses to change the standard sequence for evaluating operators. For example:

Sin(PI / 6) * (17 - ${LENGTH}) < 9    // The result is a boolean value

Operator List:

Here A is the left operand of the operator and the B is the right operand.

Operator	Description	Similar Function
/	The result of dividing A by B	Div(A, B)
*	The product of A and B	Mul(A, B)
%	The remainder of dividing A by B	Mod(A, B)
^	Returns A to the power of B	Pow(A, B)
+	The sum of two numbers A and B	Add(A, B)
-	The difference between A and B	Sub(A, B)
==	True if A equal to B and false otherwise	Eq(A, B)
!=	False if A equal to B and true otherwise	NotEq(A, B)
>	True if A is greater than B and false otherwise	Greater(A, B)
<	True if A is less than B and false otherwise	Smaller(A, B)
>=	True if A is greater than or equal to B and false otherwise	NotSmaller(A, B)
<=	True if A is less than or equal to B and false otherwise	NotGreater(A, B)
and	Logical conjunction of boolean A and B	And(A, B)
&&	Logical conjunction of boolean A and B	And(A, B)
or	Logical disjunction of boolean A and B	Or(A, B)
xor	Logical exclusive disjunction of boolean A and B	Xor(A, B)
not	Logical negation of the B	Not(B)
!	Logical negation of the B	Not(B)
in	In operator, A in [A,B] returns true	In(A, B)