Skip to main content

How To Calculate Sales Tax In Excel?

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 = ???

Tax Percentage (%) = 10

the Final price = 100

the equation is 

Tax Value  = {Final Price}-{Final Price}/(1+({Tax Percentage}/100))

Tags