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
Was this topic helpful? Send feedback.