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 Advanced 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