The range is then provided to the Excel Sum Function, which adds together the values in cells A1-B3 and returns the value 21.Ĭell C1 of the following spreadsheet shows the union operator, used to define a range made up of cells in the two ranges A1-A3 and A1-B1. Reference Operator Examples Example 1 - Excel Range OperatorĬell C1 of the following spreadsheet shows the range operator, used to define the range A1-B3. Intersection operator (returns a reference to the intersection of two ranges) Union operator (combines two references into a single reference) Range operator (defines a reference to a range of cells) The Excel Reference Operators are used when referring to ranges within a spreadsheet. This is illustrated in the following examples: Arithmetic Operator Examples If a part of a formula is encased in brackets, the bracketed part of the formula takes precedence over all of the above listed operators. However, brackets can be used to force parts of a formula to be evaluated first. The order in which the arithmetic operators are evaluated makes a big difference to the result of an Excel formula. Finally, the addition and subtraction operators are evaluated. Therefore, when evaluating Excel Formulas that contain more than one arithmetic operator, the percent and exponentiation operators are evaluated first, followed by multiplication and division operators. The table above shows that the percent and exponentiation operators have the greatest precedence, followed by the multiplication and division operators, and then the addition and subtraction operators. The Excel Arithmetic Operators and the order in which they are evaluated are shown in the table below: Operator
These are: Arithmetic OperatorsĮach of these Operator types is discussed below. There are four different types of Excel Operators. The Excel Operators perform actions on numeric values, text or cell references.