You need to have the *change* in rate in your third argument, expressed
as a decimal. Try:

=SUMPRODUCT(--(D7{0;3000000;5000000}),(D7-{0;3000000;5000000}),
{0.005;0.0025;0.0025})


In article ,
abryan wrote:

JE McGimpsey, thanks for the idea - I put in the following per your site
but it returns an error...can anyone clarify what the error is?

=SUMPRODUCT(--(D7{0;3000000;5000000}),(D7-{0;3000000;5000000}),{.5%;.75%;1%})