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;
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;
#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;
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
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.
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!