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. There are 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