Thread: Sales tax VAT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jacko99 Jacko99 is offline
external usenet poster
 
Posts: 1
Default Sales tax VAT

I need aformula that will deduct 17.5% from a gross figure to give me how
much sales tax has been paid and therefore the net amount. Muliplying by
0.1489 works great on 117.50 but goes astray on any figure above that. any
help much apreciated, don't want to give the TAXMAN any more than he is due.