How can I remove the tax from a total to get the pre tax value ?

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

Guest

If I try to remove 17.5% (UK Value Added Tax) from a total it's also
calculating the additional 17.5% on the original value as well. How can I get
to the true original value?
 
Hello:

Strong argument for basic alegbra.

Let $T = amount of tax
let i= tax rate
let x = inclusive amount
let y = amount exclusive of tax
x = y + t*y
x = y*(1+t)
x/(1+t) = y
$T = x - y
or in one formula:
$T = x - x/(1-t)
Row/Col A B
19 Example
20 t= 0.175
21 x= 1
22 $T = 0.14893617 =C21-C21/(1+C20)
23 y = 0.85106383 =C21-C22
24 y = 0.85106383 =C21/(1+C20) Alternative

Pieter Vandenberg

: If I try to remove 17.5% (UK Value Added Tax) from a total it's also
: calculating the additional 17.5% on the original value as well. How can I get
: to the true original value?
 
TaxedPrice = OriginalPrice*(1.175)
So: OriginalPrice = TaxedPrice / 1.175
With TaxedPrice in A1 use =A1/1.175
best wishes
 
Just a brief Thanks to all that responded.
Rick's was the first option I tried and that worked a treat!

All the best!
DD
 
Back
Top