Operators and Constants

Operators and constants

The following operators are supported in expressions:

Operator Name Description Example usage
+ Addition Adds two numbers 5+PI (8.14159..)
- Subtraction Subtracts a number from another Year()-2000 (19)
* Multiplication Multiplies two numbers 4*7 (28)
/ Division Divides a number with another 67/10 (6.7)
^ Exponent Raises a number to a power 10^3 (1000)
% Modulus Remainder of division 2345%100 (45)
& Binary AND Binary AND 14&7 (6)
| Binary OR Binary OR 14|7 (15)
# Binary XOR Binary Exclusive OR 14#7 (9)
~ Binary complement Binary Complement ~160 (95)
> Greater than Logical compare 10>9 (1)
< Less than Logical compare 10<9 (0)
>= Greater than or equal Logical compare 10>=9 (1)
<= Less than or equal Logical compare 10<=9 (0)
== Equal to Logical compare 10==9 (0)
&& Logical AND Logical AND 10&&9 (1)
|| Logical OR Logical OR 10||9 (1)
! Logical NOT Logical invert !(10==9) (1)
!! Make boolean Forces result to be boolean !!8 (1)
E 10th power Raise to 10th power 3.14E3 (3140)
PI π Constant Pi PI (3.14159…)
E e Natural Logarithm E (2.71828…)
? : Conditional (C)?(X):(Y) If C is true then X, else Y (f(3)>100)?(f(4)):(f(5))