Forum Discussion
Multiple IF/AND Formula
mathetes see attached. I just want to be able to plug and play with the number of deals in rows 2 & 3 and change the dollar values for each tier in rows 8 & 9 or the number of deals required for each tier in rows 12 & 13 and then have them be able to see what they could potentially make each month in row 5.
By the way, there's such a big jump in the bonus when, for example, a person goes from Tier 2 to Tier 3 in the Certainli category. Going from 9 to 10 is great for the person who hits 10, really tough on the person who worked just as hard, maybe harder, but only made 9.
You might want to consider adopting a system that works something like the US Federal Tax system, where an additional dollar income, putting you "from one bracket into the next up" actually only costs the person that higher rate for that last dollar. Granted, it's the reverse of your situation in some ways, since the bonus system is paying out whereas the tax system is asking you to pay. But that graduated tax table is a good concept.
I've attached a calculator for Federal Taxes as an example--- this is more complicated, since it handles multiple years as well as multiple levels of income. But it illustrates my point about moving from one bracket to another.
- OK, Thank you so very much for this. This is above and beyond! Much appreciated