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 |
Microsoft Excel Tutorials, Calculation with percentage using Microsoft Excel, Microsoft Excel Video Tutorials, Microsoft Excel Advanced Tutorials, Microsoft Excel VBA Macros
No comments:
Post a Comment