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%