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

"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?