Thread: How can I remove the tax from a total to get the pre tax value ?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default How can I remove the tax from a total to get the pre tax 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

"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