Add, Subtract, Multiply and Divide Numbers in an Excel worksheet


The below mentioned tutorial will guide on how to add, subtract, multiply and divide numbers in an excel worksheet using the standard built in formulas. To carry out of the above mentioned mathematical operations, insert some numerical data into the excel worksheet.

Below is an example worksheet data that we are using to illustrate the process of addition, subtraction, multiplication and division operations on numbers.


Figure 1




To add Numbers, do the following

1) Select the Range of cells that you want to add and do the following


Figure 2




a) Click on the “Formulas” tab and then under the Formulas tab, in the ‘Function Library’ category, click on the drop down arrow of the ‘AutoSum’ command and select the option that says ‘Sum’.


Figure 3



b) Now the ‘Sum’ of all the numbers present in the cells that you selected will be displayed in a cell below the last cell of the selected range of cells.


Figure 4



c) You can also add the numbers by manually typing the SUM formula in a cell below the selected range of cells. To achieve this, taking into consideration our illustration, type the formula =SUM(B3:B9) and press Enter and the result of addition operation will be displayed in the cell where you entered the formula.


Figure 5




To Subtract Numbers, do the following

There is no separate formula such as SUBTRACT in the excel application that you can use to subtract numbers. Instead, you can have the numbers that you want to subtract as negative numbers and use the SUM formula to obtain the subtraction result. For example, if you want to subtract the numbers 34 and 56 from 150, then type the formula as =SUM(-34,-56,150) to obtain the exact result.

In our illustration, we intend to find out the difference in revenue between the months of JAN and Feb. to do so, type the formula as =SUM(C4-C3) to obtain the exact difference in revenue.


To Multiply Numbers, do the following

You can use the PRODUCT Formula to achieve multiplication of numbers. For example, in our illustration, we intend to find out the product of two numbers that are present in the cells B3 and B5. To achieve this, type the formula =PRODUCT(B3,B5) in a cell where you want the excel program to display the result.


Figure 6




You can easily use any combination of numbers with a maximum limit of 255 in the PRODUCT Function. For example, the formula =PRODUCT(B3,C3:C5,D4,6) will multiply the value present in cell B3, values present in the cell range C3 to C5, value present in D4 and a constant number 6.



To Divide Numbers, do the Following

Similarly to the absence of SUBTRACT Command, there is also no separate command or function called DIVIDE for dividing numbers in the excel application. Instead, you should use the cell references combined with the standard division ‘/’ symbol to obtain division operation.

For example, in our illustration, we intend to find the cost of each product in different months by dividing the Revenue by the total product sales.

To find the cost or price of each product in the month of JAN, use the formula =(C3/B3). Similarly to find the cost price of each product in the month of Feb, use the formula =(C4/B4).


Figure 7



So, this is how you can Add, Subtract, Multiply and Divide Numbers in an excel Worksheet in Microsoft Excel 2010 Application.



Read Other Applications