CALCULATION WITH PERCENTAGE USING MICROSOFT EXCEL

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.

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

CALCULATION WITH PERCENTAGE USING MICROSOFT EXCEL

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.

Microsoft Excel Tutorials, Calculation with percentage using Microsoft Excel, Microsoft Excel Video Tutorials, Microsoft Excel Advanced Tutorials, Microsoft Excel VBA Macros