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....
Bookmarks