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.

#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.

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

#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.

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

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.

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

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!