Thanks Toppers

This is a little easier to understand for SUMPRODUCT newby's like myself

Matt


"Toppers" wrote:

Based on the McGimpsey formula:

=SUMPRODUCT(--(A1{0;20000;40000;60000;80000;100000}),
(A1-{0;20000;40000;60000;80000;100000}), {0.05;0.01;0.01;0.01;0.01;0.01})

HTH

"Bearacade" wrote:


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