software

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/ColAB
19Example
20t=0.175
21x=1
22$T =0.14893617=C21-C21/(1 C20)
23y =0.85106383=C21-C22
24y =0.85106383=C21/(1 C20)Alternative

Pieter Vandenberg

David gt; 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?

Divide figure by 47, then multiply by 7.
Eg. 117.5 / 47, then * 7 = 17.5

HTH
--
Big Rickquot;Davidquot; wrote:

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

TaxedPrice = OriginalPrice*(1.175)
So: OriginalPrice = TaxedPrice / 1.175
With TaxedPrice in A1 use =A1/1.175
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Davidquot; gt; wrote in message
...
gt; If I try to remove 17.5% (UK Value Added Tax) from a total it's also
gt; calculating the additional 17.5% on the original value as well. How can I
gt; get
gt; to the true original value?
Total amount in A1

=A1/(1 0.175)

will give you the non taxed values--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;Davidquot; gt; wrote in message
...
gt; If I try to remove 17.5% (UK Value Added Tax) from a total it's also
gt; calculating the additional 17.5% on the original value as well. How can I
gt; get
gt; to the true original value?
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

quot;Davidquot; wrote:

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