I want to create an excel spreadsheet where I can enter my hours and it calculate what I will recieve on my paycheck after all deductions.
I know how to use excel, i just dont know what math to use to find out what my weekly federal deduction is.
I know how to get the medicare and FICA or whatever, but I cant figure out what formula one uses to get their federal withholding. can anyone help?
2007-08-07 09:00:19 · 2 answers · asked by imapirateaarr 5 in Business & Finance ➔ Taxes ➔ United States
WOOT, thank you Judy. That site was a huge help, now I got my formula.
Just have to make it pretty now...../sigh
(damn 4 hour wait time for best answer)
2007-08-07 09:44:45 · update #1
The federal withholding formula is quite complex and probably something you don't want to try in a spreadsheet. If you want to give it a shot, download IRS Publication 15 - there are tables in that to show the calculation.
You might want to try http://www.paycheckcity.com/ to calculate your net.
2007-08-07 09:06:49 · answer #1 · answered by Judy 7 · 1⤊ 0⤋
Go to www.paycheckcity.com, they have a payroll calculator, that you can use instead of excel spreadsheet.
2007-08-07 09:10:11 · answer #2 · answered by Anonymous · 0⤊ 0⤋