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

Something like this. For the Case Else section, adjust the formula as needed.

Function MainTax(myCost As Double)

Select Case myCost
Case Is <= 0.1: MainTax = 0
Case Is <= 0.2: MainTax = 0.01
Case Is <= 0.4: MainTax = 0.02
Case Is <= 0.6: MainTax = 0.03
Case Is <= 0.8: MainTax = 0.04
Case Is <= 1: MainTax = 0.05
Case Else
MainTax = Round(myCost * 0.05, 2)
End Select

End Function


"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

Somehow it always takes posting my reply to realize I should have added
something or done it slightly differently. It looks like maybe your Case
Else formula should be RoundUp(myCost * .05, 2)

"B Lynn B" wrote:

Something like this. For the Case Else section, adjust the formula as needed.

Function MainTax(myCost As Double)

Select Case myCost
Case Is <= 0.1: MainTax = 0
Case Is <= 0.2: MainTax = 0.01
Case Is <= 0.4: MainTax = 0.02
Case Is <= 0.6: MainTax = 0.03
Case Is <= 0.8: MainTax = 0.04
Case Is <= 1: MainTax = 0.05
Case Else
MainTax = Round(myCost * 0.05, 2)
End Select

End Function


"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

On Tue, 20 Apr 2010 15:11:02 -0700, B Lynn B
wrote:

Somehow it always takes posting my reply to realize I should have added
something or done it slightly differently. It looks like maybe your Case
Else formula should be RoundUp(myCost * .05, 2)

The State of Maine Sales tax is 5%, with arithmetic rounding. The 5% sales tax
table is inconsistent with the instructions which read

"Where the tax to be paid includes a fraction of one cent, the fraction is not
required to be paid where it is less than one-half cent. A full cent, however,
must be paid where the fraction is one-half cent or more."

If that is true, then the formula would be simply:

=ROUND(A1*5%,2)

On the other hand, if the Table takes precedence, then:

=INT(A1)*5% +
VLOOKUP(MOD(A1,1),{0,0;0.11,0.01;0.21,0.02;0.41,0. 03;0.61,0.04;0.81,0.05},2)

should give you the "table" answer.
--ron

=ROUND((Amt+0.1*(MOD(Amt,1)0.2))*0.0499,2)

"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

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

Nothing wrong with that. But on second thought, the following is probably
clearer and maybe even more efficient:

=IF(A1<=0.1, 0, ROUNDUP(A1*5%,2))


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

"Joe User" wrote:
"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

Try $1.10

"Herbert Seidenberg" wrote:
Try $1.10

I did. Try reading the assumptions in my posting. The OP failed to tell us
how sales tax is computed above $1. So I wrote: "Assuming tax of $0.06 an
amounts between $1.01 and $1.20".

And IF(A1<=0.1,0,ROUNDUP(A1*5%,2)) is indeed $0.06.

However, I have since looked up the Maine sales tax information [1]. I
learned that the tax table included by the OP applies only to amounts of
"less than" [sic] $1.

For amounts over $1, the rule is: "Where the tax to be paid includes a
fraction of one cent, the fraction is not required to be paid where it is
less than one-half cent. A full cent, however, must be paid where the
fraction is one-half cent or more."

So it appears that the correct formula is:

=IF(A1<=0.1,0,IF(A1<=1,ROUNDUP(A1*5%,2),ROUND(A1*5 %,2)))

("<=1" matches the column title of the Maine tax tables. And "<1" makes no
difference.)

So ironically, tax on $1.10 is indeed $0.06.

(But tax on $1.01 to $1.09 is $0.05. New information, new results!)


-----
Endnotes

[1] http://www.maine.gov/revenue/salesus...2000charts.pdf

First and foremost, I want to thank you for your time and effort. However,
tax on $1.10 is just $.05 not $.06...Therein lies my problem. The tax
schedule does not change above $1.00. The same calculations apply. But before
I get carried away, I'm going to try your formula first. Once again, thank
you very much.

"Joe User" wrote:

"Herbert Seidenberg" wrote:
Try $1.10

I did. Try reading the assumptions in my posting. The OP failed to tell us
how sales tax is computed above $1. So I wrote: "Assuming tax of $0.06 an
amounts between $1.01 and $1.20".

And IF(A1<=0.1,0,ROUNDUP(A1*5%,2)) is indeed $0.06.

However, I have since looked up the Maine sales tax information [1]. I
learned that the tax table included by the OP applies only to amounts of
"less than" [sic] $1.

For amounts over $1, the rule is: "Where the tax to be paid includes a
fraction of one cent, the fraction is not required to be paid where it is
less than one-half cent. A full cent, however, must be paid where the
fraction is one-half cent or more."

So it appears that the correct formula is:

=IF(A1<=0.1,0,IF(A1<=1,ROUNDUP(A1*5%,2),ROUND(A1*5 %,2)))

("<=1" matches the column title of the Maine tax tables. And "<1" makes no
difference.)

So ironically, tax on $1.10 is indeed $0.06.

(But tax on $1.01 to $1.09 is $0.05. New information, new results!)


-----
Endnotes

[1] http://www.maine.gov/revenue/salesus...2000charts.pdf

.

On Tue, 20 Apr 2010 23:53:45 -0700, "Joe User" <joeu2004 wrote:

"Herbert Seidenberg" wrote:
Try $1.10

I did. Try reading the assumptions in my posting. The OP failed to tell us
how sales tax is computed above $1. So I wrote: "Assuming tax of $0.06 an
amounts between $1.01 and $1.20".

And IF(A1<=0.1,0,ROUNDUP(A1*5%,2)) is indeed $0.06.

However, I have since looked up the Maine sales tax information [1]. I
learned that the tax table included by the OP applies only to amounts of
"less than" [sic] $1.

For amounts over $1, the rule is: "Where the tax to be paid includes a
fraction of one cent, the fraction is not required to be paid where it is
less than one-half cent. A full cent, however, must be paid where the
fraction is one-half cent or more."

So it appears that the correct formula is:

=IF(A1<=0.1,0,IF(A1<=1,ROUNDUP(A1*5%,2),ROUND(A1* 5%,2)))

("<=1" matches the column title of the Maine tax tables. And "<1" makes no
difference.)

So ironically, tax on $1.10 is indeed $0.06.

(But tax on $1.01 to $1.09 is $0.05. New information, new results!)


-----
Endnotes

[1] http://www.maine.gov/revenue/salesus...2000charts.pdf

I think it's more complicated.

I see a discrepancy between the written information and the table.

The written rules seem to be a straight 5% with simple "arithmetic rounding".

Using the table, however, gives different results. And it seems to me that the
fractional dollar table also applies to amounts over $1:

"This table shows tax to $100 by units of $1.00. The tax to be collected is the
amount indicated below^ for each even dollar of the sale price plus the amount
indicated above* for the remainder of the sale price."

^below = the whole dollar table
*above = the fractional dollar table.

For example: $1.25

From the even dollar table: $0.05
From the fractional table: $0.02

Your formula will give results inconsistent with the table for a number of
values.

At least, the whole dollar table seems to be straight 5%.
--ron