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 850B11: =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
Bookmarks