Formula(s) needed for Tiered Commission structure

You can use Lookup without a range of cells.

Please Login or Register  to view this content.

Assuming the percentage to lookup is in cell A1

If however A1 is your target and B1 is achieved and you dont have a dedicated percentage cell then

Please Login or Register  to view this content.

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.