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