Forum Discussion
Multiple IF/AND Formula
Hi there, I am trying to do a formula based on a tiered system. So an employee gets paid out per deal based on how many deals they get. See example below. So for February they would get paid out $30...
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
