Operators for expressions in validation rules

Arithmetic operators

+

Plus

Field[1]+Field[2]=Field[3]

-

Minus

Field[1]-Field[2]=Field[3]

*

Multiply

FieldC<=FieldA*10

/

Divide

Field[1]/2=Field[4]

^

Power

2^3 = 8

%

Remainder

FieldA%2=0 (If the statement is true, then the field contains an even value. Otherwise, the value is odd.)

Relational operators
(Only for conditions to be evaluated. Not for actions.)

=

Equal to

Field[1]+Field[2]=Field[3]

>

Greater than

Field B>FieldC

<

Less than

FieldC<5

>=

Greater than or equal to

Field[1]>=Field[4]

<=

Less than or equal to

FieldA<=FieldB+FieldC

<>

Not equal to

FieldA<>FieldB+FieldC

Logical operators
(Only for conditions to be evaluated. Not for actions.)

And

Logical And

FieldA=FieldB+FieldC And FieldA<Field[3]

A And B is true if both A and B are true.

For use between two expressions.

Or

Logical Or

FieldA=FieldB+FieldC Or FieldA<Field[3]

A Or B is true if A, B, or both A and B are true.

For use between two expressions.

Not

Logical Not

Not FieldA=FieldB+FieldC

Not A is true if A is false.

Xor

Logical Xor

FieldA=FieldB+FieldC XOr FieldA<Field[3]

A Xor B is true if either A or B, but not both, is true.

For use between two expressions.

String operator (for use between two expressions)

&

Concatenation

"Alley" & "Hoop" returns "AlleyHoop"