I am looking for an easy way to calculate the fee based on the market value
of hundred of individual accounts.

The fee has various breakpoints - for example:

0 - 10,000 1% ( first 10,000)
10,001 - 100,000 .50% (Next 90,000)
100,001 - 500,000 .25% ( Next 400,000)
500,001 - 1,000,000 .10% ( Next 500,000)


Thus I would like a worksheet that would have one column with the Market
Value and another column with the fee amount. ( May be other columns to
assist with the calculation)

I am hoping to avoid nesting many if, then statements.

Any thoughts?

Thanks for your time and assistance