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.
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.
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).
Watch the Video Tutorial
Microsoft Excel Tutorials, Calculate Taxes using Microsoft Excel, Microsoft Excel Video Tutorials, Macros to perform tasks, Microsoft Excel 2013
No comments:
Post a Comment