Tiered Pricing

	A	B	C	D	E
1	Amount	Fee	Delta
2	0	0.13%	0.13%		C2: =B2-N(B1)
3	1,000,000	0.11%	-0.02%
4	5,000,000	0.09%	-0.02%
5	10,000,000	0.06%	-0.03%
6
7	Amount	Fee	Blended
8	548,935	714	0.130%		B8: = SUMPRODUCT((A8 > $A$2:$A$5) * (A8 - $A$2:$A$5) * $C$2:$C$5)
9	12,322,000	11,593	0.094%		C8: =B8/A8
10	1,500,000	1,850	0.123%