View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
 
Posts: 905
Default How do I apply State O Maine 5% Sales Tax schedule to $ amounts.

"Bamforth" wrote:
Subject: How do I apply State O Maine 5% Sales Tax
schedule to $ amounts.


It is hard to say for sure without seeing the rest of the tax table, at
least through $2. Assuming tax of $0.06 an amounts between $1.01 and $1.20,
I would say:

=(A10.1)*ROUNDUP(A1*5%,2)

Note: This assumes that A1 is already rounded to the penny; that is,
=ROUND(formula,2).


----- original message -----

"Bamforth" wrote:
Maine 5% Sales Tax Schedule

From To Tax
$0.00 $0.10 $0.00
$0.11 $0.20 $0.01
$0.21 $0.40 $0.02
$0.41 $0.60 $0.03
$0.61 $0.80 $0.04
$0.81 $1.00 $0.05

If you normaly multiple 10 cents by .05 it equals $0.01.... That would be
wrong under their tax schedule. Can anybody help me? Thank you