Commision.xlsx

<div>
Thank you Rob for the spreadsheet and this is something that I can definitely work off of and modify for what we need for our sales people to track their commission structure.
</div>


Thank you Rob for the spreadsheet and this is something that I can definitely work off of and modify for what we need for our sales people to track their commission structure.

<div>
<div class="content wysiwyg-content">
We are trying to build and excel spreadsheet for our sales people on their commission they earn and are have difficulties putting in the correct formulas. &nbsp;Here is what we are trying to accomplish. &nbsp;If a Sales Person make a sale to ABC company on 1/1/17 for a 36 month period for $1000.00 they are paid in percentages in the given form. &nbsp;Month 1 -12 they are paid 10%, 13 - 24 @ 4%, 25 - 36 @ 1% and commission is ended at the the end of the 36th month. &nbsp;Any advise would be helpful to get on the right track.<br />
<br />
Thank you in advance.
</div>
</div>


We are trying to build and excel spreadsheet for our sales people on their commission they earn and are have difficulties putting in the correct formulas.  Here is what we are trying to accomplish.  If a Sales Person make a sale to ABC company on 1/1/17 for a 36 month period for $1000.00 they are paid in percentages in the given form.  Month 1 -12 they are paid 10%, 13 - 24 @ 4%, 25 - 36 @ 1% and commission is ended at the the end of the 36th month.  Any advise would be helpful to get on the right track.

Thank you in advance.

Excel Formula for Commission Structure

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.

Sales

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.