I'm working on a sales commissions template. The bonus structure is as
follows:
over 101% of budget but below 105% of budget, the rep receives a bonus of
1%. If the rep exceeds their budget by 105% and over, the rep receives a 2%
bonus. I've worked out the over 105% budget bonus structure but I'm having
troubles working out the "over 101% but below 105% budget" calculation. Any
help is appreciated.