thankQ Help
Operator |
Description |
Example |
XLS(x) Format Export-Friendly See Note |
+ |
Adds the value of one numeric expression to another or concatenates two strings. |
[UnitPrice] + 4 |
Yes |
- |
Finds the difference between two numbers. |
[Price1] - [Price2] |
Yes |
* |
Multiplies the value of two expressions. |
[Quantity] * [UnitPrice] * (1 - [BonusAmount]) |
Yes |
/ |
Divides the first operand by the second. |
[Quantity] / 2 |
Yes |
% |
Returns the remainder (modulus) obtained by dividing one numeric expression by another. |
[Quantity] % 3 |
Yes |
| |
Compares each bit of its first operand to the corresponding bit of its second operand. If either bit is 1, the corresponding result bit is set to 1. Otherwise, the corresponding result bit is set to 0. |
[Flag1] | [Flag2] |
Yes |
& |
Performs a bitwise logical AND operation between two integer values. |
[Flag] & 10 |
Yes |
^ |
Performs a logical exclusion on two Boolean expressions, or a bitwise exclusion on two numeric expressions. |
[Flag1] ^ [Flag2] |
Yes |
== |
Returns true if both operands have the same value; otherwise, it returns false. |
[Quantity] == 10 |
Yes |
!= |
Returns true if the operands do not have the same value; otherwise, it returns false. |
[Country] != 'France' |
Yes |
< |
Less than operator. Used to compare expressions. |
[UnitPrice] < 20 |
Yes |
<= |
Less than or equal to operator. Used to compare expressions. |
[UnitPrice] <= 20 |
Yes |
>= |
Greater than or equal to operator. Used to compare expressions. |
[UnitPrice] >= 30 |
Yes |
> |
Greater than operator. Used to compare expressions. |
[UnitPrice] > 30 |
Yes |
In (,,,) |
Tests for the existence of a property in an object. |
[Country] In ('USA', 'UK', 'Italy') |
Yes |
Between (,) |
Specifies a range to test. Returns true if a value is greater than or equal to the first operand and less than or equal to the second operand. |
[Quantity] Between (10, 20) |
Yes |
And |
Performs a logical conjunction on two expressions. |
[InStock] And ([ExtendedPrice]> 100) |
Yes |
Or |
Performs a logical disjunction on two Boolean expressions. |
[Country]=='USA' Or [Country]=='UK' |
Yes |
Not |
Performs logical negation on an expression. |
Not [InStock] |
Yes |
