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