Forum Discussion
Solved
Calculating Commissions with escalator clause
Hi, I am trying to calculate commissions with an escalator clause and break it out by month. In column A I have the date the deal closed. In column E I have the amount of the deal, with E29 totaling ...
See the attached workbook.
Not sure if the above is clear - my goal is to have each month show my expected commission keeping in mind the commission structure
Does the escalator start over each month? Or only at the beginning of the year?
- Hi,
the escalator starts over at the start of the new Fiscal year, which is April. Capturing that piece of that isnt essential - I can always make another box of months to capture if needed. Thank you,See the attached workbook.