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