jayseeca Wrote:
for the first example on the site you directed me to.... would the
formula
change of the first tax rate was not 0%?


Because, in your example, the tax starts at 0 you need the first array
(containing the bands) to start at 0, i.e. for the example you give

=SUMPRODUCT(--(A1{0,5000,10000,20000}),A1-{0,5000,10000,20000},{0.14,-0.04,-0.02,-0.03})

..or a modified version of Elkar's suggestion....

=MEDIAN(A1,5000,0)*0.14+MEDIAN(A1-5000,5000,0)*0.1+MEDIAN(A1-10000,10000,0)*0.08+MAX(A1-20000,0)*0.05


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=543842