On 2002-10-02 16:00, mrjimmy wrote:

Ok. So it looks like most of my problem was due to some lousy documentation that I have on using IF. Thanks for all your advice - here's the *blazingly* obvious and simple way I solved this:

=IF(E16>=37411,((E16-37410)*.46)+11087,IF(E16>=32651, ((E16-32650)*.42)+9088,IF(E16>=27891, ((E16-27890)*.38)+7279,IF(E16>=23131, ((E16-**23103**)*.34)+5661,IF(E16>=18361, ((E16-18360)*.30)+4230,IF(E16>=13601, ((E16-13600)*.26)+2992,IF(E16<=13600, (E16*.22))))))))

-jim

The benefit to setting up a table like this:

{0,0,0.22;13601,2992,0.26;18361,4230,0.3;23131,5661,0.34;27891,7279,0.38;32651,9088,0.42;37411,11087,0.46}

in G1:I7

and using the formula

=INDEX($G$1:$I$7,MATCH(E16,$G$1:$G$7),2)+INDEX($G$1:$I$7,MATCH(E16,$G$1:$G$7),3)*(E16-(MAX(0,(INDEX($G$1:$I$7,MATCH(E16,$G$1:$G$7),1)-1))))

would be it is easy to update info if it changes. (note what I believe to a type in bold in your formula above). As long as it works for you that great, but having information in one place has its advantages.