Home  >  Article  >  Topics  >  How to use addition and subtraction formulas in excel

How to use addition and subtraction formulas in excel

尚
Original
2019-06-14 16:35:4912164browse

How to use addition and subtraction formulas in excel

Add in Excel: You can use the automatic sum function in the toolbar to add, or you can directly enter the SUM formula or A1 in the output data cell. B1 form to find the sum.

Subtraction in Excel: Same as addition, you can subtract by entering the form A1-B1 in the cell of the output result.

The specific steps are as follows:

1. First, make your own form, as shown below:

How to use addition and subtraction formulas in excel

2. Select "Formula" in the toolbar and click "AutoSum-Sum"

How to use addition and subtraction formulas in excel

##3. The results are as follows:


How to use addition and subtraction formulas in excel

4. You can also select the unit to output the result and manually enter the SUM function, as shown below:

How to use addition and subtraction formulas in excel

5. The same principle applies , for subtraction operation, you can first select the cell, enter the row and column numbers of the minuend and the subtrahend in fx, and press Enter

How to use addition and subtraction formulas in excel

More Excel related technical articles, Please visit the

Excel Basic Tutorial column!

The above is the detailed content of How to use addition and subtraction formulas in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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