Operators in Excel specifies the type of calculation to be performed on a given set of values. Excel has a rich variety of operators to perform calculative actions on a given set of data.
Types of Operators in Excel
Basically, there are 4 crude types of operators in Excel, mentioned as below:
- Arithmetic Operators
- Logical/Comparison Operators
- Text Concatenation Operator
- Reference Operators.
Each type consists of a set of operators which are specifically meant for that particular group (except Text Concatenation Operator, which has only one operator).
Arithmetic Operators are used for arithmetic operations like addition, subtraction, multiplication, division etc.
Precedence of Arithmetic Operators
Though these operators have the precedence over each other, brackets can be used to precede some specific operators and can be evaluated first.
Logical or Comparison Operators are used in excel to logically compare the two values (numeric or text). These operators compare two values (provided through cells or separately) and return a logical output i.e. TRUE or FALSE.
Text Concatenation Operator
Excel has one operator which helps to join in two or more text strings and produces a single text line. We can use the ampersand (&) operator to join two or more strings and get a single text line.
Excel reference operators are used to refer the ranges from your excel spreadsheet in a formula.
In cell C2, we can see the range operator. It takes a range of all cells starting from A2 to B6 under SUM function and returns sum of all 10 values.
Cell C2 of the excel spreadsheet shows the functioning of union operator. It takes two ranges as a reference, first from column A ( A2 : A6) and other as (A2 : B3) under SUM function. Finally, it produces sum of these two references and gives value 56.
Cell C2 of the excel spreadsheet shows the functioning of the intersection operator. It takes two ranges as a reference, first from column A ( A2 : A6) and other as (A2 : B3) under SUM function. Finally, it produces a sum of values in the cells which are common in both ranges (i.e. cell A2 : A3) which is 7.