# Thread: Complex Commission Calculation Question

1. ## Complex Commission Calculation Question

Hello !

I have a complex commission question and wondering if someone can help me with that. It goes like:

For the first 10 units, I get a commission of $150. From 11 to 20 (the next 10 units), I get$200. For the next 10 units (from 21 to 30), I get $250. What would be the formula to know the commission of 600 units (or any number of unit (it could be 610 units also)? Thank you for your kind help. 2. ## Re: Complex Commission Calculation Question Your post gives no commission rule after 30 units so im not sure how we are supposed to comment on the commission for 600 units. From the information, exactly as you posted it, i get: number of units = x commission = 150*min(x,10) + 200*min(max(x-10,0),10) + 250*min(max(x-20,0),10) The above formula assumes that no commission is paid after the 30th unit (which is where you stopped your post). Test before use. Answer Your rule and the above formula gives Commission for 600 units = Commission for 30 Units = 6000 3. ## Re: Complex Commission Calculation Question If the commission is increased by$50 after every 10 units, then it form an arithmatic series so you can use the formula for A.S
$S_{n}=\frac{n}{2}(2a+(n-1)d)$

4. ## Re: Complex Commission Calculation Question

Originally Posted by waqarhaider
If the commission is increased by $50 after every 10 units, then it form an arithmatic series so you can use the formula for A.S $S_{n}=\frac{n}{2}(2a+(n-1)d)$ Thats valid for n when it is divisible by 10. You need to add an adjustment for the remainder. 5. ## Re: Complex Commission Calculation Question Hello ! Thank you for your kind replies. Well there is no commission rules as to the number of units. It could be any number of units. If I use that arithmetic sequence, I don't know how to set it up. I'll state the question again: For the first 10 units, the commission is$150. The next 10, $200. The next 10,$250, the next 10, \$300

In this way it goes on. So i need to specifically find specific units, eg. 417 units or 587 units, etc.