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

=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:

=(A1>0.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:
> =(A1>0.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:
>
> =(A1>0.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" <herbds7-(E-Mail Removed)> 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" <herbds7-(E-Mail Removed)> 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 15:11:02 -0700, B Lynn B <(E-Mail Removed)>
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