Home > Topics > excel > body text

Use of table difference formulas

藏色散人
Release: 2019-06-10 14:01:56
Original
6590 people have browsed it

Use of table difference formulas

How to find the difference in Excel table?

How to use the table difference formula:

Step 1: Open the Excel table, click the first row, the third "cell" , that is, C1, enter "=A1-B1" in C1;

Use of table difference formulas

The second step: the meaning of this formula is: A1-B1=C1, first The number in one cell "minus" the number in the second cell "equals" the third cell. You might as well give it a try and enter the number you need to find the difference;

Use of table difference formulas

#As shown in the picture, I entered 50 in A1 and 60 in B1, and the result is in C1 The answer appeared directly: -10.

Of course, you can also enter more numbers that need to be differentiated into the cells in the second row, third row, fourth row, etc. to get more results, as shown in the figure;

Use of table difference formulas

At this point, there is still one less step to find the difference. Let's first click to select cell C1, and then when the mouse turns into a black cross, hold down the left mouse button and drag it down; as shown below

Use of table difference formulas

After dragging, release the mouse and you will see all the results displayed.

how? Have the results of the difference come out? Keep it simple! And the results are accurate.

Use of table difference formulas

This article comes from the Excel basic tutorial column: http://www.php.cn/topic/excel/

The above is the detailed content of Use of table difference formulas. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template