===== 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))'' |