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. For more information on the order in which operators are evaluated, see Using operators in formulas.
Related topics 
About formulas