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.
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%
if they sell more than 1500 units above target, it will remain 5.5%
- HansVogelaar Thank you. Got the solution 👌
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.