Thread: How do I apply State O Maine 5% Sales Tax schedule to $ amounts.
View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default How do I apply State O Maine 5% Sales Tax schedule to $ amount
On Fri, 23 Apr 2010 01:36:42 -0700, "Joe User" <joeu2004 wrote:

ROUND(MOD()) is necessary. I think the ROUND of the sum is prudent; it
ensures that comparisons with hardcoded sales tax amounts match when
expected.

<slap on forehead. Thanks to you and Herbert for again pointing out the
issues with Excel Rounding. We should be using it more.
--ron
Reply With QuoteReply With Quote