Hi thedon_1,

minus-minus formula converts each TRUE value to 1 and FALSE value to 0

Let's try breakdown the formula, with assumption that A1=2000000...
Formula: copy to clipboard 
=--(A1>{0,1000000,5000000})

=--(2000000>{0,1000000,5000000})

=--({2000000>0,2000000>1000000,2000000>5000000})

=--({TRUE,TRUE,FALSE})

={1,1,0}


Formula: copy to clipboard 
=A1-{0,1000000,5000000}

=2000000-{0,1000000,5000000}

={2000000-0,2000000-1000000,2000000-5000000}

={2000000,1000000,-3000000}


Thus when we SUMPRODUCT, it will sum up the arrays

Formula: copy to clipboard 
=SUMPRODUCT(--(A1>{0,1000000,5000000}),A1-{0,1000000,5000000},{0.01,-0.003,-0.001})

=SUMPRODUCT({1,1,0},{2000000,1000000,-3000000},{0.01,-0.003,-0.001})

=SUMPRODUCT({1*2000000*0.01,1*1000000*(-0.003),0*(-3000000)*(-0.001)})

=SUMPRODUCT({20000,-3000,0})

=20000-3000+0

=17000




_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin