How to complete a 2006 Tax Income Irs Table
Q.This must have been done before, but for the life of me I cannot figure out how (for a cell that contains taxable income), to complete a IRS income Table taxes from a set of rules without VBA. Has anyone done this before. Income Is Over But Not Over This Amount Plus This % Of the Excess Over.Some informations in 2006 0 14,000 0 0.1 0 14,000 56,800 1,400 0.15 14,000 56,800 114,650 7,820 0.25 56,800 114,650 174,700 22,283 0.28 114,650 174,700 311,950 39,097 0.33 174,700
A.Been done before. I used Ron de Bruin's google search add in using "tax" and got http://tinyurl.com/poxp you can scale it down to 3 columns, make a table as this 0 0.0 0.1 14,000 1,400 0.15 56,800 7,820 0.25 114,650 22,283 0.28 174,700 39,097 0.33 call the table tax or something, put the earned amount in A1 then use a formula like =VLOOKUP(A1,Tax,2)+(A1-VLOOKUP(A1,Tax,1))*VLOOKUP(A1,Tax,3) (to name the table, select the dimensions of the raw data, click in the name box above the row and column header and type the name there or do insert>name>define and type it there)
Other Questions :
If the IRS has until 2006 to review the tax return
What is the time limit for cashing an IRS refund check? My son received a refund check last May for the 2002 tax year. He neglected to cash it. He believes that he had only 90 days to cash an IRS refund check. So he believes the refund c...
I'm looking for a better way to IRS free file that tax return? Any suggestions for me ?
I'm looking for a better way to IRS free file that tax return? Any suggestions for me ? Thank for replyAbout 62 million Americans found an easier way to file their income tax forms in 2004, according to the Internal Revenue Service. That...
IRS Online tax filing / prep question
This question might sound like I am out of date... My friend has 2 kids with very small incomes. Is there a way to do 1. Free online tax prep from IRS and 2. Free efiling for both Federal and CA state taxes ? Are there any web sites t...
What is a 1040-ES Form Irs ?
I received a 1040-ES in the mail today. I am not sure why I am receiving this. Is this a manditory form Irs ? Is it telling me that I made a mistake from last year? I guess I am not sure why I am receiving this form... I have never gotte...
I went to the irs.gov site and looked at free efile.
I used to use telefile to file my 4868, automation extension for the form 1040. That has been discontinued. Now, we are supposed to use a free efile site. I went to the irs.gov site and looked at free efile. Most don't have 4868 and tho...