Yes, a different method is probably better. (Not paying taxes would be
even better.)
At each cutoff point the tax is some number (X), plus a percentage of
income above the cutoff point.
So, you probably want a lookup table for the base amount, plus a
percentage calculation for the income above the base amount.
For example
col A col B col C
col D
Income Range Tax at Bottom of Range
Incremental %
Low High
20,000.01 25,000.00 500.00 15%
25,000.01 30,000.00 1,250.00 20%
Assume the taxable income is in cell Z99.
Tax can be found by
=Vlookup(Z99,A:D,3,TRUE) + ' tax at
bottom of range Vlookup(Z99,A:D,4,TRUE)*
' incremental rate
(Z99-VLOOKUP(Z99,A:D,1,TRUE)) '
incremental taxable income
--
rsenn
------------------------------------------------------------------------
rsenn's Profile:
http://www.excelforum.com/member.php...o&userid=29050
View this thread:
http://www.excelforum.com/showthread...hreadid=491290