The following operators are available for creating logical expressions in validation rules:
* |
multiplication |
/ |
division |
+ |
plus |
- |
minus |
> |
greater than |
< |
less than |
>= |
greater or equal |
<= |
less or equal |
= |
equal |
!= |
not equal |
and |
logical and |
or |
logical or |
The operators in this table are listed in order of operator precedence. Operator precedence means that operators higher up in the table are evaluated before operators that are listed after them. Therefore, A = B or C = D and A + B * D = Cis evaluated as ((A = B) or (C = D)) and ((A + (B * D)) =C).