Percentages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I live in South Texas and our sales taxes is 8.25%. I am trying to come up
with the formula for figuring out the total amount of sale before tax when
taxes have already been added to it. For Example: If total sales were
$108.25 including the taxes what was the total sales before taxes. I know
the answer is $100, however what is the formula to get it.
 
One way:

A1: 108.25
A2: =A1/(1 + 8.25%)

or, equivalently:

A2: =A1/(1.0825)
 
Thank you so much...Something so simple yet, I just couldn't get it together.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Income Tax 7
Calculate sales tax 3
Totaling the same cells from different sheets 8
CHECK BOX - Can I use it as a sales tax yes or no calculation ? 1
sales tax total amount from one cell amount to another cell 1
Populate empty cells to use for conversion 1
spreadsheet with negitive numbers 1
Need help creating an Excel formla to calculate price before sales tax 3

Back
Top