Hi,
I hope I'm explaining what I want to do correctly here.
I'm attempting to create a formula that will multiply a cell by multiple options, depending on the value of that cell. This is for sales/commission purposes, for example;
If Jane sold between 1-6 units she would be paid at $75 per unit, and if she sold between 7-12 units she would be paid at $100 per unit (13-18 sales = $150 per unit and 19+ sales = $200 per unit)
So what I'm looking to do is enter in the total sales made by Jane into a cell, and depending on that number it would then calculate the commission in another cell using the above criteria. See below for an image:
Commissions.PNG
Let me know if further details or an example spread sheet is needed, thank you in advance.
Bookmarks