How to customize complex formula calculations in Excel

Definition method: First open an excel table, select the specified cell, and enter "=" in the cell; then click on the cell to be calculated, and then enter the multiplication and division of the formula; then press the Enter key and the mouse Move it to the edge of the cell and turn it into a " " sign; finally double-click or pull down the mouse.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.

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

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

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

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.

Then enter your calculation multiplication, which is * and then click C2, as shown in the picture

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.

After pressing the Enter key, 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 below. That's it.

Related learning recommendations: excel tutorial

The above is the detailed content of How to customize complex formula calculations in Excel. For more information, please follow other related articles on the PHP Chinese website!