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