MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Which tax table to use formula


Posted by CPU Nut on October 18, 2001 11:05 AM

I am creating a spreadsheet, where I enter employees names, their maritial status and their income. Based on income and the maritial status, I need to know what their tax deduction (based on my formula per bracket) would be. I am half way there, I can tell it which tax bracket to use, but I can't seem to figure out the formula for it to know WHICH table to use based on marital status (each table is different) if anyone is up for the challenge, please email me at cpuxnut@yahoo.com. I have a sample ready to go. I am about ready to give up!!!! (Thanks for the help so far from some of you guys!!! And at least trying!!!!)


Posted by Aladin Akyurek on October 18, 2001 11:40 AM

It's

=(C4-VLOOKUP(C4,IF(B4="M",MSCHEDULE,SSCHEDULE),9))*VLOOKUP(C4,IF(B4="M",MSCHEDULE,SSCHEDULE),7)+VLOOKUP(C4,IF(B4="M",MSCHEDULE,SSCHEDULE),5)

[ and the workbook is underway to you. ]

Aladin

PS. I was quite a bit distracted, whence so late.

============