Controlling Sales in Units Based on Buyer Requirements

Hi,



​Wish you are all having a great start of the week!



Hope anyone can help me in crafting a formula for the below:



Basically, we have monthly sales in units. Specifically, we are required to sell a certain amount of our units to a particular buyer.

In this case, we are required to sell 25% of the units atleast UNTIL the cumulative units we sold to this buyer reached 15,625.

Once that number is breached, the amount of units we are required to sell to them goes down to 10%.



On top of the above, there is a yearly limit applied. If the cumulative sales is less than 15,625, for every year, there's a cap on how much we are able to sell.

For example, in this case, the cap is 7,125 per year. However, once the 15,625 is breached, the cap will not be there anymore (there is no limit to how much we can sell).



I attached a simple example in this thread. The line in bold (line 16) is what I need but as a formula.

If anyone knows how to go about doing this, would really appreciate the help.



Thanks!

Welcome to the forum.

Whilst I have a look at this, please take a moment to read our simple foirum rules, in particular the one about thread titles, which must NOT be generic. I have changed yours for you this time.