Tiered Fee Calculator

  • Hi All,

    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?


  • Re: Tiered Fee Calculator

    Hi Broady,

    Have a look at the attached worksheet. I have used a table for the charges in cells A2:B4. I have then used a Named Formula for the Charge, called 'Charge'. It means that you can type a value anywhere in the Spreadsheet and one cell to the right type =charge and it will give you the charge for that value.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!