I'm trying to develop a formula to calculate a sales team incentive bonus. A
bonus amount is calculated based on sales made, but then is adjusted 3 months
later based on the criteria below.


Less than 50% of sales still on the books 0% payable
50% to 60% of sales 25%
61% to 70% of sales 50%
71% to 80% of sales 75%
81% to 90% of sales 100%
Over 90% of sales 125%

I'm afraid I don't know where to start - can anyone point me in the right
direction?

Thanks