Calculate Taxes (How to File Income Tax) - Formulas In Excel - Microsoft Excel Tutorials

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

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 - https://www.youtube.com/watch?v=BQQ6mGwyd8I

  Hope You Like This Tutorial - Give Comments