Microsoft Excel Functions & Formulas

Calculation with percentage

Let’s say you want to buy a new car. The listed price of the car is

$25,500, and the tax to be added is 8%. After negotiating a sales

discount of 10%, the final price has to be calculated.

4

To calculate the final price:

1. Select cell B1 and enter 25500.

2. Select cell B2 to enter the tax rate of 8%.

3. Select cell B3 and enter the discount rate of 10%.

4. Select cell B5 and type the following formula:

=B1*(1+B2)*(1-B3).

Note: As you see in cell C5 in Figure 1-26, the formula

=B1*(1–B3)*(1+B2) also works. The order of multiplication

does not matter.

Formulas in Excel

27

1

Figure 1-26