Home  >  Article  >  Topics  >  How to use self-built formulas in Excel to calculate?

How to use self-built formulas in Excel to calculate?

coldplay.xixi
coldplay.xixiOriginal
2020-06-17 13:45:3725695browse


How to use self-built formulas in Excel to calculate?

How to calculate using self-built formula in Excel?

Excel calculation method using self-built formulas:

1. First, we create and open an excel table on the desktop for demonstration.

How to use self-built formulas in Excel to calculate?

#2. The results of the demonstration are as follows. After customizing a formula in the table, the calculation results below are calculated by this formula.

How to use self-built formulas in Excel to calculate?

3. We first double-click in the demonstration cell, and then enter the = sign, as shown in the figure.

How to use self-built formulas in Excel to calculate?

#4. Then click the cell to be calculated with the mouse, for example, click E2, E2 will be displayed in the cell, and then the dotted box will be displayed in the E2 cell.

How to use self-built formulas in Excel to calculate?

5. Then enter your multiplication operation, that is, * and then click C2, as shown in the picture

How to use self-built formulas in Excel to calculate?

6. Because the unit price before tax * quantity = the total price before tax, put them in parentheses first, and then multiply them by the tax rate.

How to use self-built formulas in Excel to calculate?

7. Then press the Enter key and there will be an operation result. Then move the mouse to the lower right corner of the cell and a black number will be displayed. Drag it Just go down there. As shown in Figure 2

How to use self-built formulas in Excel to calculate?

How to use self-built formulas in Excel to calculate?

Recommended tutorial: "excel basic tutorial"

The above is the detailed content of How to use self-built formulas in Excel to calculate?. 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