# Operators

The following operators can be used throughout the system in Formulas.

Operator | Definition |
---|---|

* | multiply |

/ | divide |

+ | add |

- | subtract |

== | equals |

!= | not equals |

>= | greater or equal to |

<= | less than or equal to |

> | greater than |

< | less than |

~= | contains |

!~= | does not contain |

The operator !~= will not work in Document Templates. As an alternative, you can use ~= as a "contains", inside of an extra set of parentheses with an exclamation point in front of it as a "not". For instance, instead of something like `$startif($field_name !~= "substring")`

, you can try something like `$startif(!($field_name ~= "substring"))`

Variable Formula fields use a slightly modified syntax and list of operators. For more information, see Variable Formula Fields.

# Logical Operators

You can combine formula criteria using logical operators such as AND and OR. These are:

Operator | Definition | Example |
---|---|---|

|| | Or | `($priority == High || $priority == Low)` |

&& | And | `($contract_amount >= 50000 && $approval_required == 'Yes')` |

# Order of Operations

Formula expressions are evaluated from left to right. Use parentheses to group terms and define the order of execution. For example, A && (B || C) will evaluate to true if A is true, and also B or C is true. In contrast, A && B || C will evaluate true if A and B are true, OR if C is true.