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