# # Order of precedence

HyperFormula supports multiple operators that can be used to perform mathematical operations in a formula. These operators are calculated in a specific order. If the formula contains operators of equal precedence, like addition and subtraction, then they are evaluated from left to right.

## # Table of precedence

In the table below you can find the order in which HyperFormula performs operations (from highest to lowest priority).

Precedence | Operator | Description |
---|---|---|

1 | : (colon) , (comma) (space) | Reference operators: range (colon), union (comma), intersection (space). Currently supported by HyperFormula only at the grammar level of a function. |

2 | – | Negation |

3 | % | Percent |

4 | ^ | Exponentiation |

5 | * and / | Multiplication and division |

6 | + and – | Addition and subtraction |

7 | & (ampersand) | Concatenation of two or more text strings |

8 | < (less than) = (equal to) > (greater than) <= (less than or equal to) >= (greater than or equal to) <> (not equal to) | Comparison |

## # Using parentheses

HyperFormula calculates the formulas in parentheses first so by using them you can override the default order of evaluation. For instance, consider this formula: =7 * 8 + 2. After the equal sign, there are operands (7, 8, 2) that are separated by operators (* and +). Following the order of calculations, HyperFormula computes 7*8 first and then adds 2. The correct answer to this equation is 58.

Placing (8+2) in parenthesis will change the result as HyperFormula will first calculate 8 + 2 = 10, and after that will multiply it by 7. Now the result is 70, not 58 as in the first example.