Hi,
=VLOOKUP(A1,TaxTable,2,TRUE)
Where A1 contains the taxable income, the range, here called TaxTable is a 3
column table with taxable income in the first column sorted in ascending
order, columns 2 and 3 containing the tax for single or married. 2 tell you
which column applies to you 2 or 3. A two would mean you are single. True
mean that you are doing an approximate match. Which is what you want in a
tax situation. Substitiute the range where your tax table is for TaxTable in
my formula.
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
