ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Percentages (https://www.excelbanter.com/excel-discussion-misc-queries/37936-percentages.html)

www.javysgifts.com

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

JE McGimpsey

One way:

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

or, equivalently:

A2: =A1/(1.0825)

In article ,
www.javysgifts.com
wrote:

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.


www.javysgifts.com

Thank you so much...Something so simple yet, I just couldn't get it together.

"JE McGimpsey" wrote:

One way:

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

or, equivalently:

A2: =A1/(1.0825)

In article ,
www.javysgifts.com
wrote:

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.




All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com