About calculation operators in Excel

In Excel there are four different types of operators:

Arithmetic operators  

Comparison operators  

Text concatenation operator  

Reference operators 

The following descriptions are reproduced from Excel’s Help file for your ready reference. In the present lecture you are directly concerned with arithmetic operators. However, it is important to learn that the comparison operators are used where calculations are made on the basis of comparisons. The text concatenation operator is used to combine two text strings. The reference operators include “:” and “,” or ; as the case maybe. We shall learn the use of these operators in different worksheets. You should look through the Excel Help file to see examples of these functions. Selected material from Excel Help File relating to arithmetic operations is given in in a separate file.

The Excel arithmetic operators are as follows:

Addition. Symbol: +                     (Example: =5+4 Result: 9)

Subtraction. Symbol: -                 (Example: =5-4  Result: 1)

Multiplication. Symbol: *              (Example: =5*4  Result: 20)

Division. Symbol: /                      (Example: =12/4 Result: 3)

Percent. Symbol: %                    (Example: =20% Result: 0.2)

Exponentiation: ^                         (Example: =5^2   Result: 25)

Previous

TOC

Next