Perhaps another option:

=MIN(0.1%*A1+1650,0.2%*A1+650,0.3%*A1+150,0.45%*A1 )

--
HTH :)
Dana DeLouis


"Schorn" wrote in message
...
What would be the best way to calculate a total based using criteria like
the
following:

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.