Blog

Operators in MS Excel

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.

Leave a Reply

Your email address will not be published. Required fields are marked *