what would be the formula for seperating the tax from an amount?

N

Nuts in New Mexico

If I hava dollar amount of 106. how would I seperate the tax and the pretax
amount?
 
F

Frank Kabel

Hi
if your tax is 15% use
1. Pretax:
=A1/(1+0.15)

2. Tax value
=A1-A1/(1+0.15)

--
Regards
Frank Kabel
Frankfurt, Germany

"Nuts in New Mexico" <Nuts in New (e-mail address removed)>
schrieb im Newsbeitrag
news:[email protected]...
 
C

CarlosAntenna

a1=6% {tax rate}
b1=106 {your dollar amount}
c1=b1/(a1+1) {pre-tax amount}
d1=b1-c1 {tax amount}
 
M

mzehr

Hi,
I am assuming that if you were a total of $106 you want to know what the
base amount was and the tax on the sale. To do that you would need to know
what the tax rate for the jurisdiction was. Assuming that you know that you
would divide $106 by the (1+tax rate) Therefore if the tax rate is 6% you
would divide 106 by 1.06 and get $100 as the base. The difference between
the base and your total is the tax
 

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

Compute Tax? 0
Allocate an income payment over a date range (tax years) 7
Needing help with a Function on Excel. 2
Calculating tax on rebates 2
looking for a function that will populate opening a worksheet or t 2
GST 3
Help with calculating tax percentages 2
Tax formula tests for multiple filing statuses and income amounts 1

Top