Using operators in formulas

Creating a solution > Working with formulas and functions > 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