look up tables for tax schedules
 

I know there is a simple way to use look up tables to compute 2005 tax
schedules as referenced below but I can not find an easy formula to do
this. I would appreciate any help on this.

Thanks,

George



2005 Tax Schedule - Married Filing Jointly

But Not % on of the
Over Over Pay Excess amount over
$- $14,600 $- 10.0% $-
14,601 59,400 1,460 15.0% 14,600
59,401 119,950 8,180 25.0% 59,400
119,951 182,800 23,318 28.0% 119,950
182,801 326,450 40,916 33.0% 182,800
326,451 88,320 35.0% 326,450

1)PUt your table "as is" so the first value (the zero) is in Cell A3
2)Put any taxable amount in cell H1
3)Put this forumula in cell I1:
=VLOOKUP(H1,$A$3:$E$8,3,1)+(H1-VLOOKUP(H1,$A$3:$E$8,5,1))*VLOOKUP(H1,$A$3:$E$8,4, 1)

Does that help?

Regards,
Ron

Ron,

That works great. Thank you very much.

Again, I appreciate your help.

George