Importing tax tables?

[bmorris]

Good morning!
What is the most efficient way to import the IRS federal withholding wage bracket tables for use in excel to calculate an employees FIT tax to be withheld? There are a few different factors that must be considered when calculating an employees FIT....for example; marital status, exemptions claimed on W-4 and amount of pay. I am totally open to suggestions as to the best way to get this done within excel!!!!
Thank you in advance for any suggestions! Brandy

 

[number kruncher]

Does the IRS website provide tables, which you can select then copy/paste into Excel.

Then you could use data, as an array to interogate.

 

[bmorris]

Yes there are tables.....my challenge is there are at least 3 factors to be considered to figure out the amount to withhold.
Here is the link......take a look......the tables begin on page 38.
http://www.irs.gov/pub/irs-pdf/p15.pdf