I am trying to put together a fee calculator for use on investment products. I am getting stuck with some of the tiered products offered in the market.
eg. Fee is calculated as:
$0-$100,000 - 0.65%
$100,000-$200,000 - 0.55%
$200,000-$500,000 - 0.45%
In this instance, an account value of $150,000 would be charged thus:
$100000 - $650
$50,000 - $275
For one product, I can probably use a basic IF function. Does anyone know how to calculate the fee across multiple products, using differing fee structures?