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**

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/Comparison Operators**

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.

**Reference Operators**

Excel reference operators are used to refer the ranges from your excel spreadsheet in a formula.

**Range Operator**

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.

**Union Operator**

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.

**Intersection Operator**

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.