# 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).
Reference operators: range (colon), union (comma), intersection (space).
Currently supported by HyperFormula only at the grammar level of a function.
|5||* and /||Multiplication and division|
|6||+ and –||Addition and subtraction|
|7||& (ampersand)||Concatenation of two or more text strings|
< (less than)
= (equal to) > (greater than)
<= (less than or equal to)
>= (greater than or equal to)
<> (not equal to)
# 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.