Using operators in formulas
An operator is a symbol or instruction that manipulates expressions in a formula. For example, the plus (+) operator tells FileMaker Pro to add one expression to another. FileMaker Pro has four types of operators:
 •
Mathematical operators
 •
Comparison operators
 •
Logical operators
 •
Text operators
Note  For information on using variables in formulas, see Using variables.
Order of evaluation
Operators are evaluated in the order they are listed below.
1.
/* */, //
2.
" ", \, ¶, ${ }
3.
(, )
4.
NOT
5.
^
6.
*, /
7.
+, -
8.
&
9.
=, ≠, >, <, ≥, ≤
10.
AND
11.
OR, XOR
Related topics 
About formulas
Was this topic helpful? Send feedback.