Tiered Pricing formula

Hi. I was away...

=SUMPRODUCT(--(A2>{0,300,700,1200,1800}),--(A2-{0,300,700,1200,1800}),{0,3,3,2,2})

explanation of : {0,3,3,2,2}

This is the DIFFERENCE between the discount at each tier level.

First tier 0
Second tier 3... difference = 3
Third tier 6... difference = 3
Fourth tier 8... difference = 2
etc....