Forum Discussion
Bonus calculation % achieved, % payout
Hi - I am trying to set up a formula that would calculate bonus payout based on achievement. Lets say someone achieved 85% of their sales, their bonus is paid out at 25%. But the payout is scaled...
Actually, I figured it out. That example file would work if my given thresholds were the only possible payouts - but all the linear amts in between the thresholds are paid out too.
EX: So if someone achieves 90%, their payout is 62.5%.
That is the part that was tripping me up.
It's been a while since your post, but can you share the final solution for your problem?