SumProduct Array Formula Help

[VinodKrishnappa]

Hi,

Can anybody explain me this formula please?

=SUMPRODUCT(--(A2>{0;250001;500001;1000001}),(A2-{0;250001;500001;1000001}),{0;0.1;0.1;0.1})

I am not able to get complete formula.

As i understood little 1st part (A2>{0;250001;500001;1000001}) explained below am i correct?

[TABLE="width: 325"]
<colgroup><col span="2"><col><col span="2"></colgroup><tbody>[TR]
[TD]Slab
[/TD]
[TD]Rate[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]2,50,001[/TD]
[TD="align: right"]0.10[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]45,000[/TD]
[/TR]
[TR]
[TD="align: right"]5,00,001[/TD]
[TD="align: right"]0.10[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0
[/TD]
[/TR]
[TR]
[TD="align: right"]10,00,001[/TD]
[TD="align: right"]0.10[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0
[/TD]
[/TR]
</tbody>[/TABLE]

Please help me to understand the function completely.

 

[arthurbr]

See McGimpsey & Associates : Excel : How differential rates work