Forum Discussion
Solved
Commission calculation based on variable targets
Hello Excel Masters and Experts, I am stuck in a formula, i need your help to solve it. I'm attaching an excel sheet and all the information has been written on it. (cOMMISSION CAL.xlsx) Looking f...
OK, so the 1500 doesn't play any role in this. See the attached version. I created a small lookup table and used a VLOOKUP formula.
Could you be so kind to answer the question that I asked?
The answer of Q1: When they sell up to 250 units above target,
The answer of Q2: Under the Commission Calculations section there is a column (sold amount), the percentage will be applied to that.
The answer of Q2: Under the Commission Calculations section there is a column (sold amount), the percentage will be applied to that.
Thank you. So the sales rep gets 5.5% commission if they sell between 1000 and 1500 units above target.
But what if they sell more than 1500 units above target? Does it remain 5.5%?
- That's correct:
if they sell more than 1500 units above target, it will remain 5.5%OK, so the 1500 doesn't play any role in this. See the attached version. I created a small lookup table and used a VLOOKUP formula.