Excel help: I'm trying to input a dollar value into a cell and have the output be the federal income tax for that amount (just using the brackets). Federal income tax is calculated such that the first x dollars are taxed at rate R, the next y dollars are taxed at rate S, and up through several different rate brackets. I can do this calculation with a simple IF statement using multiple cells by summing the result of 5 separate bracket calculations. I'm not sure if I can cram it into one giant formula. Suggestions? [more inside]
Yet another tax question, sorry. We're confused about our tax situation this year. Details: we were married last June, so this is our first time filing together. We make almost equivalant salaries (48,000 and 54,000), sold ~14,000 in mutual funds this year, invested ~900 in one 401k, and paid about 2400 in student loan interest. We don't own a home. One of us claimed 1 exemption, the other claimed 2.
(more inside) [more inside]