How to use subtraction in Excel

How to use subtraction in Excel?

First of all, we see that the table in the picture needs to use the difference method. Did you see it? Some students said it is very simple. You only need to do the calculations orally to get the result. But this is just an example. If the data is remembered in actual applications, it cannot be completed by oral calculation, and the error rate is still very high.

Recommendation: "excel tutorial"

Looking at the picture, what we need to do is to find the results in E3, everyone knows That's C3-D3, let's start next.

First select E3 with the mouse and enter "=" in it.

Next, we use the mouse to select C3, and then a dotted frame will appear, indicating that this cell has been selected.

#Then continue to enter the symbol "-" in E3, which means subtraction.

Use the mouse to select D3, and a dotted frame will also appear. At this time you will see that there is already a formula in the E3 table.

Finally press Enter to get the result. The difference in the following columns can also be calculated using the same method, but it is very troublesome.

We now need a simple method to make it easier to find the difference in the following columns. We first select E3. Move the mouse to the lower right corner of the cell. You will find a small cross, and then drag the cross down, just like the format painter, the cells in the column will have results.

The above is the detailed content of How to use subtraction in Excel. For more information, please follow other related articles on the PHP Chinese website!