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