PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

INTRODUCTION TO FORMULAS:ARITHMETIC OPERATORS

A BRIEF INTRODUCTION TO FORMULAS WAS ALREADY GIVEN IN THE VERY FIRST POST What Excel does? How to use formula in Excel?

BUT NOW LET US MOVE FORWARD AND UNDERSTAND THE TERMINOLOGY, SYSTEM AND PROCEDURES WHICH WILL BE FOLLOWED IN FURTHER LEARNING

 

WHAT IS A FORMULA IN EXCEL?

A formula is a combination of digits and operators which return us a desired result after calculating that particular phrase.

Similar is the case of formula in Excel. If there were no FORMULAS in Excel, it would have been a simple word processing software like WORD.

FORMULA IN EXCEL can have mathematical operators, Excel functions and cell addresses or absolute values to process the calculations.

We will discuss each of them in details step wise step.

ARITHMETIC OPERATORS PERMITTED IN EXCEL

Following operators are permitted in Excel formula

 

OPERATOR FUNCTION
+
STANDARD ADDITION
-
STANDARD SUBTRACTION
/
STANDARD DIVISION
*
STANDARD MULTIPLICATION
^
EXPONENTIATION (POWER)
&
CONCATENATE

ARITHMETIC OPERATORS: DESCRIPTION

STANDARD ADDITION

Its one of the basic and widely used operators used in EXCEL FORMULAS. It adds the value of different operands.

USAGE:

FORMULA FORMAT:WHEN ABSOLUTE VALUES ARE USED
 
Type the following phrase in the cell
=value1+value2+value3+….
e.g. if we want to add 14, 22 and 45, the formula will be something like this.
Place the cursor in the cell , where we want the result to appear and type this
=14+22+45
The answer will appear in the cell as 81
 
FORMULA FORMAT: WHEN CELLS ADDRESSES ARE USED.
=cell address containing first value+cell address containing second value+… so on.
e.g. if we take the same example and suppose the three values 14,22 and 45 are put in cell number A12 A13 AND A14.
Place the cursor in A15 and put the formula
The formula will be
=A12+A13+14
The answer will appear in the cell where you put the formula say A15.

STANDARD subtraction

Its one of the basic and widely used operators used in EXCEL FORMULAS. It SUBTRACTS the value of second operand from the first one.

USAGE:

FORMULA FORMAT:WHEN ABSOLUTE VALUES ARE USED
 
Type the following phrase in the cell
=value1-value2-value 3… and so on
e.g. if we want subtract 14 from 20
Place the cursor in the cell , where we want the result to appear and type this
=20-14
The answer will appear in the cell as 6
 
FORMULA FORMAT: WHEN CELLS ADDRESSES ARE USED.
=cell address containing first value – cell address containing second value – … so on.
e.g. if we take the same example and suppose the two values of 20 and 14 are put in cell number A12 and A13.
Place the cursor in A15 and put the formula
The formula will be
=A12-A13.
The answer will appear in the cell where you put the formula say A15.

 

STANDARD DIVISION

Its one of the basic and widely used operators used in EXCEL FORMULAS. It DIVIDES the first operand from the second one and so on.

USAGE:

FORMULA FORMAT:WHEN ABSOLUTE VALUES ARE USED
 
Type the following phrase in the cell
=value1/value2
e.g. if we want to divide 20 by 10
Place the cursor in the cell , where we want the result to appear and type this
=20/10
The answer will appear in the cell as 2
 
FORMULA FORMAT: WHEN CELLS ADDRESSES ARE USED.
=cell address containing first value /cell address containing second value .
e.g. if we take the same example and suppose the two values of 20 and 10 are put in cell number A12 and A13.
Place the cursor in A15 and put the formula
The formula will be
=A12/A13.
The answer will appear in the cell where you put the formula say A15.

 

STANDARD MULTIPLICATION

Its one of the basic and widely used operators used in EXCEL FORMULAS. It MULTIPLIES all the operands.

USAGE:

FORMULA FORMAT:WHEN ABSOLUTE VALUES ARE USED
 
Type the following phrase in the cell
=value1*value2*value3… so on.
e.g. if we want to multiply 12 and 5 and 6.
Place the cursor in the cell , where we want the result to appear and type this
=12*5*6
The answer will appear in the cell as 360
 
FORMULA FORMAT: WHEN CELLS ADDRESSES ARE USED.
=cell address containing first value *cell address containing second value*cell address containing third value and so on .
e.g. if we take the same example and suppose the three values of 12,5 and 6 are put in cell number A12,A13 and A14.
Place the cursor in A15 and put the formula
The formula will be
=A12*A13*A14.
The answer will appear in the cell where you put the formula say A15.

 

exponentiation(raising to the power)

It finds out the value when we raise the power of any number.

USAGE:

FORMULA FORMAT:WHEN ABSOLUTE VALUES ARE USED
 
Type the following phrase in the cell
=number^power
e.g. if we want to raise 2 to the power 5 i.e. 25
Place the cursor in the cell , where we want the result to appear and type this in the formula bar
=2^5
The answer will appear in the cell as 32.
 
FORMULA FORMAT: WHEN CELLS ADDRESSES ARE USED.
=cell address containing number^cell address of cell containing power.
e.g. if we take the same example and suppose the two values of 2 and 5 are put in cell number A12 and A13.
Place the cursor in A15 and put the formula
The formula will be
=A12^A13
The answer will appear in the cell where you put the formula say A15.

 

concatenation

This operator attaches the text of one cell to the other. It is somewhat lesser know operator. Maximum people use the function directly even for the two values.

USAGE:

FORMULA FORMAT:WHEN ABSOLUTE VALUES ARE USED
 
Type the following phrase in the cell
=content 1& content2 &… so on
This function has not much importance to be used when we have absolute content as we can directly write that into the cell itself. Even then if we use the operator it’ll work.
Place the cursor in the cell , where we want the result to appear and type this in the formula bar
=2&5
The answer will appear in the cell as 25.
 
FORMULA FORMAT: WHEN CELLS ADDRESSES ARE USED.(Practically useful)
=cell address containing number&cell address of cell containing power&…..so on.
e.g. if we take the same example and suppose the two values of 2 and 5 are put in cell number A12 and A13.
Place the cursor in A15 and put the formula
The formula will be
=A12&A13
The answer will appear in the cell where you put the formula say A15.

 

logical OPERATORS PERMITTED IN EXCEL

Following logical operators are permitted in Excel formula

 

OPERATOR FUNCTION
=
EQUAL TO
>
GREATER THAN
>=
GREATER THAN OR EQUAL TO
<
LESS THAN
<=
LESS THAN OR EQUAL TO
<>
NOT EQUAL TO

logical OPERATORS: DESCRIPTION

example of adjusting the row height

OTHER WAYS TO REACH THIS ARTICLE

  • HOW TO PUT FORMULA IN EXCEL, EXCEL BASICS, ARITHMETIC OPERATORS IN EXCEL, HOW TO ADD, SUBTRACT IN EXCEL, WHAT IS THE USE OF & IN EXCEL, HOW TO RAISE POWER IN EXCEL

LEARN

  • EXCEL
  • HTML
  • JAVASCRIPT
  • MORE TO COME…

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: