Jul 17 2021 03:55 AM
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 forward to the solution.
Thanks in advance
Jul 17 2021 04:37 AM
When exactly does the sales rep get 2% commission? When they sell up to 250 units above target, or when they sell at least 250 units above target?
And what (which column) is the commission percentage applied to?
Jul 17 2021 04:51 AM
Jul 17 2021 04:52 AM
Jul 17 2021 05:39 AM
Could you be so kind to answer the question that I asked?
Jul 17 2021 06:32 AM
Jul 17 2021 06:41 AM - edited Jul 17 2021 06:42 AM
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%?
Jul 17 2021 06:55 AM
Jul 17 2021 07:05 AM
SolutionOK, 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.
Jul 17 2021 07:44 AM
Jul 17 2021 07:05 AM
SolutionOK, 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.