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

Was this topic helpful? Send feedback.