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 Advanced evaluates formulas from left to right, performing multiplication and division before addition and subtraction. Using parentheses lets you change the order: FileMaker Pro Advanced evaluates expressions between parentheses first. See Using operators in formulas. |

Was this topic helpful? Send feedback.