Microsoft Excel Functions & Formulas

Calculate taxes

In this exercise, tax on an item has to be calculated. We can also

find the original price given the tax rate and the final price.

4

To calculate the price with tax:

1. Select cell A2 and type 8%.

2. Select cell B2 and type 120.

3. Select cell C2 and type the following formula:

=B2+B2*A2.

4

To calculate the original price:

1. Select cell A4 and type 8%.

2. Select cell C4 and type 129.60.

3. Select cell B4 and type the following formula:

=C4/(1+A4).

Formulas in Excel 13

1

Figure 1-12