Forum Discussion
Excel formula with commission based tiers
Hello! I can't wrap my head around how to create this formula. In cell I20 I have an employee's net sales. In I21 I want to create a formula that will give their commission earnings. So fo...
Let me suggest you arrange your table something like the IRS does its tax tables.
Doing so, and you'll want to play with this to make sure it's giving you the results you want, I came up with the following.
See the attached