The method of calculating the difference value of Excel data

the method of calculating the difference value of Excel data

Method One: Use the formula

1, select C2 cell, enter "=A2-B2", and then press ENTER, you can get the result of the second line.

2. Place the cursor in the lower-right corner of the C2 cell, press the left mouse button and drag down until it is in the right place to release the mouse when it is black and solid.

3, OK, task completed, c column has been the corresponding column A and column B cell values of the difference.

Method Two: Using functions

Subtraction is the inverse of addition, for example, "A1-B1" can also be written as "a1+ (-B1)", so you can add a minus sign before the second parameter of the SUM function to achieve the difference.

1. Select the C2 cell, switch to the Formulas tab, and in the function Library group, click the Auto Sum button.