Try TT Now

Autotrader Formula Operators

Note: You cannot use formulas in Order Block.

In formulas with more than one operator, Autotrader evaluates operators in the order of precedence included in the table below. Operators with a higher precedence number are evaluated first. Operators with the same precedence number are evaluated from left to right in the formula.

Precedence can be overridden by using parentheses to explicitly specify the order of evaluation. In formulas with conditional operators, the second and third operands can be any type, including ranges.

Example

The formula...

 =@SUM(A1 ? B1..C20 : C10..D15)

...returns the sum of B1..C20 if A1 evaluates to non-zero; otherwise it returns the sum of C10..D15.

Formulas can contain the following operators to define relationship between values:

OperatorPrecedenceDefinition

%

14

Unary percent

**

13

Exponentiation

+

12

Unary plus

-

12

Unary minus

~

12

Bitwise complement (integer)

!

12

Logical not

*

11

Multiplication

/

11

Division

%

11

Remainder (integer)

+

10

Addition

-

10

Subtraction

<<

9

Shift left (integer)

>>

9

Shift right (integer)

<

8

Less Than

>

8

Greater Than

<=

8

Less Than or Equal

=

8

Greater Than or Equal

==

7

Equal

!=

7

Not Equal

&

6

Bitwise And, or String Concatenation

^

5

Bitwise Exclusive-Or (integer)

|

4

Bitwise Or

&&

3

Logical And

||

2

Logical Or

?:

1

Conditional