How can I remove the tax from a total to get the pre tax 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
David wrote:
: 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?
|