Excel First

Order of Precedence

The Order of Precedence used by Excel to calculate formulas is extremely important to know when building complex formulas.

Of course, Excel will respect all mathematical rules you learned in school, there are only a few more Operators in Excel: the Range Operators, single Space Operator, Union Operator, the Concatenation Operator and the Exponentiation Operator.

There are 3 Reference Operators in Excel:

1.   “:” (colon) is the Range operator, which produces one reference to all the cells between two cells references, including the cells written in the reference text, like: A11:A13
2.  “,” (comma) is the Union operator, which combines multiple Ranges into one reference, like  A11:A13 , A11:C11 , A11 (you can refer to simple cells too, not only to ranges with multiple cells)
3.  ” ” (space) is the Intersection operator, which returns a reference to the cell or to the range of cells found at the intersection of the ranges. In this example, only cell A11 is found in both ranges:  A11:A13  A11:C11

The Excel Learning Journey that I propose for you, is structured in such a way as to offer you the most practical way to learn Excel, free.