Try this...

=IF(B5100000, (B5-100000)*0.1+7000, IF(B580000,(B5-80000)*0.09+5200,
IF(B560000,(B5-60000)*0.08+3600, IF(B540000,(B5-40000)*0.07+2200,
IF(B520000,(B5-20000)*0.06+1000, B5*.05)))))

Anything over 100K, you are basically paying $7000 on the first 100K
and then 10% on the rest, Anything from 80K - 100K, you are paying
5200 on the first 80K and 9% on the remainder and so on...

HTH


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553335