A simple method for subtracting data in Excel

1. For example, you want to calculate the value of column A data minus column B data in each row, and put the difference in column C.

#2. Enter the formula "=A1-B1" (without quotation marks) in cell "C1" and press Enter (i.e. press the "Enter" key on the keyboard).

3. Select the "C1" cell, move the mouse to the lower right corner of the "C1" cell, and a small black cross will appear. At this time, press the left mouse button and drag to the "C11" cell.

4. At this time, you will find that the difference between column A data minus column B data in each row is listed in column C of the same row.

5. In addition, Excel can also be used as a calculator. To calculate "3.1113-1.765", you can enter the formula "= 3.1113-1.765" in cell "A1" ", and then press Enter (that is, press the "Enter" key on the keyboard), then the difference value of "3.1113-1.765" will be displayed in the "A1" cell.

The above is the detailed content of A simple method for subtracting data in Excel. For more information, please follow other related articles on the PHP Chinese website!