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.