There are four different types of Operators in Excel: Arithmetic, Comparison, Text Concatenation and Reference.
Arithmetic Operators
To perform basic mathematical operations, such as addition, subtraction, multiplication, or division; combine numbers; and produce numeric results,use the following arithmetic operators.
Arithmetic
Operator

Meaning

Operation
Performed

Output

+ (plus sign)

Addition

3+3

6

 (minus sign)

Subtraction

31

2



Negation

1

1

* (asterisk)

Multiplication

3*3

9

/ (forward slash)

Divison

3/2

1.5

% (percent sign)

Percent

20%

.20

^ (caret)

Exponentiation

3^2

9

Comparison Operators
You can compare two values with the following operators. When two values are compared by using these operators, the result is a logical value either TRUE or FALSE.
Comparison
Operator

Meaning

Example

= (equal sign)

Equal
to

A1=B1

> (greater than sign)

Greater
than

A1>B1

< (less than sign)

Less
than

A1<B1

>= (greater than or equal to sign)

Greater
than or Equal to

A1>=B1

<= (greater than or equal to sign)

Less
than or Equal to

A1<=B1

<> (not equal to sign)

Not
Equal to

A1<>B1

Text Concatenation Operator
Use the ampersand (&) to concatenate (join) one or more text strings to produce a single piece of text.
Text
Operator

Meaning

Example

& (ampersand)

Connects,
or concatenates, two values to produce one continuous text value

"North" & "Wind"
results in "Northwind"

Reference Operators in MS Excel
Combine ranges of cells for calculations with the following operators.
Note: AND,OR etc are logical functions not logical operators as they return value on passing arguments.
BACK TO CHAPTER 1
Combine ranges of cells for calculations with the following operators.
Reference Operator

Meaning

Example

: (colon)

Range operator, which produces one
reference to all the cells between two
references, including the two
references.

B5:B15

, (comma)

Union operator, which combines
multiple references into one reference

SUM(B5:B15,D5:D15)

(space)

Intersection operator, which produces
one reference to cells common to the
two references

B7:D7 C6:C8

Note: AND,OR etc are logical functions not logical operators as they return value on passing arguments.
BACK TO CHAPTER 1