**Question description:**

*This user has given permission to use the problem statement for this blog.*

I want to work out fees on client accounts. i need to work out a tiered fee - first $200,000 is 0.59%, then between $200000 - $500000 is 0.37%, then if between $500,000 - $1,000,000 is 0.17% then if $1,000,000 to $2,500,000 is 0.05%

Solved by I. J. in 60 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
16/08/2018 - 02:56

Welcome, thank you for choosing Got It Pro-Excel! I'll be glad to assist you with your concern.

User
16/08/2018 - 02:56

Thanks, I have no idea where to start!

Excelchat Expert
16/08/2018 - 02:57

May you please share the data you have so I can help you with your concern? You can also paste a sample data on the document preview pane

Excelchat Expert
16/08/2018 - 02:59

Got it. I can help you with that. Before we proceed, just a friendly reminder that our policy is 1 question per session so for this session we'll be resolving this particular question.

User
16/08/2018 - 03:00

no problem

Excelchat Expert
16/08/2018 - 03:00

Ok, where do you need to add the formula?

User
16/08/2018 - 03:01

I dont know, I need to work out how much the fees will be for a client with $550000 for example

Excelchat Expert
16/08/2018 - 03:04

Ok to confirm, you need to charge the Fee against client account depending on the criteria. In your example in C9, that would fall under 0.37% charge correct?

User
16/08/2018 - 03:05

No, it is a cumulative fee, so the client with $550,000 is charged $1,180, then $2,290, then 0.17% of $50,000

Excelchat Expert
16/08/2018 - 03:08

So that would be the total of $6,610 correct?

User
16/08/2018 - 03:08

I need to do this analysis on many accounts, not just one. I know how to do it manually, or with a calculator. I need to know how I can have a spreadsheet with a hundred or so client accounts.

User
16/08/2018 - 03:09

No, the answer is $1180 plus $2290 plus 0.17% of $50,000 - so total is $

User
16/08/2018 - 03:09

sorry total is $3470

Excelchat Expert
16/08/2018 - 03:12

Ok sorry the requirement is a bit complex, please give me some time to work out with the formula

User
16/08/2018 - 03:13

I know it's complex, thats why i need help

Excelchat Expert
16/08/2018 - 03:27

Still working on the formula, thanks for your patience

User
16/08/2018 - 03:43

Are you still there?

Excelchat Expert
16/08/2018 - 03:43

Yes sorry

Excelchat Expert
16/08/2018 - 03:43

I am working on your formula in excel

User
16/08/2018 - 03:51

total fee on $550,000 is $3,555, not $3,470 sorry

Excelchat Expert
16/08/2018 - 03:54

Ok noted

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*