Hi,

I am new to excel and I took my whole Sunday searching high and low
for a formula or template (yea I guess I am lazy, but don't want to
spend my whole Sunday doing something heh, especially reinventing the
wheel) to calculate Federal withholding to organize my personal budget
and figure what-if scenarios. I finally wrote/copied code that I found
bits and pieces of. I learned a lot about tax tables and such. However,
it has come to my attention that there are at least (2) official
sources for Federal Tax tables. The trouble is, both are different and
I am not sure which one to use.

The first source is "Publication 15", aka "Circular E, Employer's Tax
Guide".
http://www.irs.gov/pub/irs-pdf/p15.pdf

The second is the "Wage Bracket Method Table for Computing Income Tax
Withholding From Gross Wages"
http://www.irs.gov/publications/p15a/21453t29.html

I made a replica (just the first part done so far that pertains to me)
of the Wage Bracket Method Table on a worksheet and am referencing the
formula's there. I will likely change the actual positions of the cell
references later, as I want it to look as close to the actual table as
possible. I figure that when I share this workbook I am creating, I
would like to have as reference things that look familiar and also
inform users how things are being calculated. I was going to learn how
to use an array, but I wasn't sure how to do that since I have a column
with the word subtract (per the Wage Table document). I will likely
make a work-around later.

So, here is my formula:
=IF(AND(A1B8,A1<=C8),((A1-E8)*F8),IF(AND(A1B9,A1<C9),((A1-E9)*F9),IF(AND(A1B10,A1<C10),((A1-E10)*F10),IF(AND(A1B11,A1<C11),((A1-E11)*F11),IF(AND(A1B12,A1<C12),((A1-E12)*F12),)))))


I hope it makes since.. and also, here is an image on fileshack of
what my table looks like, that should help.

http://img100.imageshack.us/my.php?i...axtable8iu.png

I used the cell references in the hope that next year I can just use
the table again, with it updated. I plan to distribute a workbook that
allows you to enter in your pertanant information, such as dependants,
married, etc and it update/change the formula's required to calculate
the actual withholding. In the workbook will be a worksheet to
calculate monthly budget, all unlocked so that a user can alter,
protect as they wish.

Thank you for your help in advance!

-Alden