# 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%
etc.

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?

Regards,
Andrew

• Re: Tiered Fee Calculator

Hi, and Welcome to OzGrid

You could set up a table such as shown in the attachment.

Put the value in A1 and C1 will show the total fee. Lower cells in column C show the various tier portions of the total fee. Adjust the table in column D:F to match the fee structure you are using.

## Files

• Re: Tiered Fee Calculator

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.

Bill

## Files

• Re: Tiered Fee Calculator

Thanks to both Thomach and Bill.