Creating a custom app > Working with formulas and functions > Using operators in formulas
 

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