Thu, 7 Feb 2008 21:09:00 -0800 from ash3154 <ash3154
@discussions.microsoft.com:
=MAX(0, 10%*(CD7 - $M$17*134.62 - 102), (15%*(1445 - (1*134.62) - 396))+29.4,
(25%*(CD7 - ($M$17*134.62) - 1306))+165.9, (28%*(CD7 - $M$17*134.62 -
3066))+605.9, (33%*(CD7 - $M$17*134.62 -6404))+1540.54, (35%*(CD7 -
$M$17*134.62 - 13833))+3992)

For some reason this formula picks up 25% portion.

Based on the IRS publication it should be at the 15%? What am I doing wrong

Your formula is, frankly, too complicated for me. But I would never
think to implement these sorts of calculations in any way but by a
VLOOKUP table. The great benefit of doing it that way is that the
table (which changes yearly) is separated from the formula (which
should never change). Define the table as a name and use the name in
the formula, and then you never change the formula even if the table
grows by a row.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?