In the previous post, you know how to calculate the summation in excel, and what about subtraction? Surely we can use the formula for it, and let’s check it out.

Enter all numbers you want to subtract, here we calculate the value of column A data subtracting column B data and place the difference in column C for each row.

First, enter the formula “= A1-B1 ” in the cell “C1”, and press Enter in keyboard, then you get the result of row 1.

Next, select “C1” and move the mouse to the bottom right corner of it, a small black cross appears. Left click the mouse and drag to the last row.

Now you get the method of how to subtract in excel. If there are a large amount of numbers, simply double click the small black cross, and the result is the same.