As shown below, this example will calculate the tax according to the tax-included amount in column B, with two decimal places reserved, and the tax rate is 17%. The results are shown in column d. ..

Please click to enter a picture description.

Select the D2 cell, enter the operator symbol "=" in the cell, and then click the Insert Function button.

Please click to enter a picture description.

The Insert Function dialog box pops up:

Select the "All" option in "Or Select Category";

Select the function "circle" in "Select function",

Click OK after selection.

Please click to enter a picture description.

Please click to enter a picture description.

The function parameter dialog box pops up:

Click the dialog box behind the first parameter and enter the formula "B2/1.17 * 0.17" in the dialog box;

Move the cursor to the dialog box after the second parameter, and enter "2" in the dialog box, which means to keep two decimal places.

After setting the parameters, click OK.

Please click to enter a picture description.

Please click to enter a picture description.

Return to the worksheet and calculate the tax on the order amount of 00 1.

Please click to enter a picture description.

Select cell D2 and drag the left mouse button to calculate the remaining tax amount.

Please click to enter a picture description.