Home >Software Tutorial >Office Software >A simple method for subtracting data in Excel

A simple method for subtracting data in Excel

WBOY
WBOYforward
2024-03-29 12:37:13950browse

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.

A simple method for subtracting data in Excel

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

A simple method for subtracting data in Excel

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.

A simple method for subtracting data in Excel

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.

A simple method for subtracting data in Excel

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.

A simple method for subtracting data in Excel

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!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete