Mathematical operators

Mathematical operators perform arithmetic computations.

Symbol

Name

Definition

+

Plus

Adds two values

-

Minus

Subtracts the second value from the first

*

Multiply

Multiplies each value

/

Divide

Divides the first value by the second

^

Power Of

Raises the first value to the power of the second value

( )

Precedence

FileMaker Pro evaluates formulas from left to right, performing multiplication and division before addition and subtraction. Using parentheses lets you change the order: FileMaker Pro evaluates expressions between parentheses first. See Using operators in formulas.