Supported Operators
All common arithmetic operators are supported. Boolean operators are also fully supported. Boolean expressions are evaluated to be either 1 or 0 (true or false respectively). The constants TRUE and FALSE are also available for use.
Table 2 - Supported Operators
|
Order of Precedence |
Operator |
Symbol |
|
1st (highest) |
Reference |
: |
|
2nd |
Percent |
% |
|
3rd |
Power (aka Exponent) |
^ |
|
4th |
Modulus |
%% |
|
5th |
Division |
/ |
|
6th |
Multiplication |
* |
|
7th |
Addition, Subtraction |
+, - |
|
8th (tie) |
Less Than, Greater Than* |
<, > |
|
Less Than or Equal, Greater Than or Equal* |
<=, >= |
|
|
9th |
Not Equal, Equal* |
<>, = |
|
10th |
Boolean Not |
! |
|
11th (lowest) |
Boolean Or, Boolean And |
||, && |
|
String Concatenation |
& |
|
|
Unary Plus, Unary Minus |
+x, -x |
Gray shading indicates operators not supported by Excel
Parent topic: Expressions, Operators, and Functions