Errata....

On Jul 21, 11:26 am, I wrote:
On Jul 21, 7:22 am, Schorn wrote:
I want to take varying totals of investments under management and calculate
costs related using .45% of first 100,000, .30% of next 400,000, .20% of next
500,000 and .10% of anything over 1,000,000.
[....]
=45%*min(A1,100000) + max(0,30%*min(A1-100000,400000)) +
max(0,20%*min(A1-500000,500000)) + max(0,10%*(A1-1000000))
[....]
where "table" is the following in A2:C5 :
A2: 0 B2: 45% C2: 0
A3: 100000 B3: 30% C3: =C2 + B2*(A3-A2)
A4: =A3+400000 B4: 20% C4: =C3 + B3*(A4-A3)
A5: =A4+500000 B5: 10% C5: =C4 + B4*(A5-A4)

Oops: obviously, all percentages should be of the form 0.45% instead
of 45%. I didn't see the itsy-bitsy period before all the percentages
in the OP's posting.

Note to OP: That is why is always best to write 0.45 instead of .45
-- that is, with the "superfluous" leading zero.