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