I believe the following should work just as well for Single Weekly.
Assuming that A1 is Gross Wages and B1 is Allowances:
=max(0, 10%*(A1 - B1*63.46 - 51), 15%*(A1 - B1*63.46 - 98), 25%*(A1 -
B1*63.46 - 306.80), 28%*(A1 - B1*63.46 - 424.89), 33%*(A1 - B1*63.46 -
817.03), 35%*(A1 - B1*63.46 - 1142.23))
Of course, you can save yourself some typing by replacing A1 - B1*63.46
with C1 (taxable income) computed as:
=A1 - B1*63.46
You might need to convince yourself that the single max(...) formula
above works for all combinations of allowances, given that the second
reference shows different gross-wage cut-offs and offsets for each tax
bracket. For example, for 15%, the gross wage range is $192.01 to $620
for zero allowances, but $255.47 to $683.46 for one allowance. But
also note that the offsets are -98 and -161.46 respectively. If we
call the zero-allowance gross wage limits the "taxable income" (T),
then algebraically the one-allowance case for the 15% bracket becomes:
Gross - 161.46
= (T + 63.46) - (98 + 63.46)
= T + 63.46 - 98 - 63.46
= T - 98
As you can see, the additional factor (Allowances*63.46) for the
cut-offs and offset simply cancels out.
Yes, that made it simple to understand. It has been awhile since I
have done Algebra. I need to obviously brush up before I go back to
school this spring.
I figured out my GA state taxes by hand and I could come within a few
pennies if I used the federal taxable wages, and I was over if I used
just my gross pay.
For example on one check I had $ 388.80, with 370.30 taxable
federally.
So I worked out:
370.30 - 44.25 = 326.05
326.05 - 135 = 191.05
191.05 * 6% = 11.463 + 4.42 = 15.883
from this publication.
http://www.etax.dor.ga.gov/taxguide/...xGuide2005.pdf
I am single with no (zero) allowances.
I have been working on trying to go about making a formula for this
work but I guess I will have to keep at it. I need to find a few hours
without getting interrupted I guess.
If you however, can figure a formula without taking to much of your
time, it would greatly be appreciated. I know if you made one it would
undoubtedly be far simpler than my own.
Should I get one working I will get back to you.