Thread: How can I remove the tax from a total to get the pre tax value ?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default How can I remove the tax from a total to get the pre tax value ?
Total amount in A1

=A1/(1+0.175)

will give you the non taxed values


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"David" wrote in message
...
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?


Reply With QuoteReply With Quote