Add and subtract in MS Excel

n the previous discussion, we learned how to select rows, columns, and cells in MS Excel. Let us now know how to add and subtract in MS Excel.

Addition rules

In MS Excel, first, we will learn how to add two numbers. Suppose we'll get a sum of 2 and 3. In that case, we will find the cell in the cell, select the cell and type = 2 + 3 then press Enter. Then you get the sum in the selected cell. Again, if you want to get the sum of more than 2 numbers, like 2, 3, 5, 7, 9, then select the required cell as well and enter it in Formula bar = 2 + 3 + 5 + 7 + 9, then press Enter, then the selected cell Sum is going out.

Again, if two numbers like 50 and 20 have a B2 cell and the other is in D2 cells, and want to get the sum of them in the C3 cell. In that case, select the C3 cell and enter it in formula bar = B2 + D2 then press Enter, then the sum in the cell C3 will come. In the same way, if two more than 20, 30, 40, 50, 60, 70 numbers are respectively B2, B3, B4, B5, B6, B7, and want to get them out of the sum of C5 cells. In that case, select the C5 cell and enter it in formula bar = B2 + B3 + B4 + B5 + B6 + B7 then press Inter. Then the sum in the C5 cell will come.

There may be a lot of time to work with an Excel Sheet, that instead of 4 numbers, the sum of 40 numbers is required to be found. In this case, showing the sum of 40 cells in the formula bar, time-consuming and trouble-related problems. So in this case, the formula bar can be easily added through the formula without adding 40 cell additions. The formula is SUM

Use Excel's SUM function

Suppose three numbers are 20, 30, 40, respectively, in A2, B2, and C2, in the cell (in the same row), now we will find the sum of them in F2 cells. In that case, select the F2 cell and enter the formula = SUM (A2: C2) then press Enter then the sum in the F2 cell will be returned. Or choose F2 cell and enter the formula in the formula bar and press Enter. To add 40 numbers in the same way, first, select the result of the cell that you want, then type formula bar = SUM (cell formula bar = SUM (cell number of the first number: the last cell number) and press the inter. By applying the formula in this way, you can find out the sum of any worksheet in the Work Sheet.

Again, if the three numbers 30, 40, 50 are respectively B2, B3, and B4 in the cell (in the same column) and if you want to take the sum in the D3 cell, then select the D3 cell and enter the formula = SUM (D2: D4). Now press Enter, the same sum will come to D3. Below are the pictures are shown below.

There is a special advantage of using Formula to add and subtract in MS Excel. Suppose we use a formula to sum the number of multiple numbers in one of the cells. Now if there are any mistakes in the numbers or need to change a number, then there is no need to use a new formula. By simply changing the wrong number, clicking on the result's cell or any other cell will correct the automatic sum.

It can be added to MS Excel using another method. If you want to sum out the cells next to the number you add, then you can quickly make use of Auto Sum. This means that the cells next to the number will be added, select the cell at the end of the row, and the last cell on the column, then click on Auto Sum, then press Enter. Very soon the sum will come to the next cell. Show it through the photo below.

Regulations to subtract

The subtraction formula is = cell number of the first number - the second number of cell addresses

Suppose a number is 1000 (which is in cell B2) from the second digit 300 (which is in cell C2) and we will find out the result in the E4 cell. In this case, select the E4 cell and enter it in formula bar = B2-C2, then press Enter, then the result of the E4 cell will be returned. We have already said that the advantage of using a formula is that if the number is wrong or changed, then clicking on the result cell will automatically correct it.