Thread: How do I apply State O Maine 5% Sales Tax schedule to $ amounts.
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default How do I apply State O Maine 5% Sales Tax schedule to $ amounts.
=ROUND((Amt+0.1*(MOD(Amt,1)0.2))*0.0499,2)

Reply With QuoteReply With Quote