Formula(s) needed for Tiered Commission structure

Hi Charly6s and welcome to the forum.

To better understand and so that we can see the question in context it is best if you will upload a small sample Excel Workbook that best expresses what you are working with and what the expected outcomes are ... hand typed if necessary. Please be sure to desensitize the data.

You often get more response and faster solution if you do so ... and please no screen shots or pictures.

If you are not familiar with how to do this:

To attach a file to your post:

1. click “Go Advanced” (next to Post Quick Reply – bottom right),
2. scroll down until you see “Manage Attachments”, click that,
3. click “Browse”.
4. select your file(s)
5. click “Upload”
6. click “Close window”
7. click “Submit Reply”
8. The file name will appear at the bottom of your reply.