Tiered Pricing Help!

Welcome to the board.

	A	B	C	D
1	Amt	Fee	delta
2	0	0.85%	0.85%	C2: =B2 - N(B1)
3	250,000	0.70%	-0.15%
4	500,000	0.60%	-0.10%
5	1,000,000	0.45%	-0.15%
6	2,500,000	0.25%	-0.20%
7	5,000,000	0.15%	-0.10%
8	10,000,000	0.10%	-0.05%
9
10	Amt	Fee Amt
11	100,000	850		B11: =SUMPRODUCT((A11 > $A$2:$A$8) * (A11 - $A$2:$A$8) * $C$2:$C$8)
12	200,000	1,700
13	500,000	3,875
14	1,000,000	6,875
15	2,000,000	11,375
16	5,000,000	19,875
17	10,000,000	27,375
18	20,000,000	37,375
19	50,000,000	67,375
20	100,000,000	117,375