Sales Tax

How To Calculate Sales Tax In Excel?

we have two type of Saels Tax

- The final price include the sales tax

- The final price exclude the sales tax

Now lets find the tax value for each one 

The final price include the sales tax

Net Price = 100

Tax percentage (%) = 10

Final price = ???

the equation is 

Tax Value = (Net Price * Tax Percentage / 100)

Final Price = {Net Price} + {Tax Value}

The final price exclude the sales tax

Net Price = ???