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
|