I think I need a loop to say that if a salesperson meets 80% of the sales target, or $96,000 (because $120,000 * 80% equals $96,000), then the commission rate of 25% starts. But, the 25% commission only takes place until the salesperson hits $120,000. Once the salesperson exceeds $120,000, the acceleration factor of 1.25 begins. This will allow the salesperson to make a commission rate of 31.25% (25% * 1.25) for as much as he/she can sell for the year.
>= 96,000 to <= 120,000 will allow the salesperson to start earning 25% commission.
> 120,000 will allow the salesperson to start earning 31.25% commission.
< 96,000 will not earn the salesperson any commission.
Does anyone have any idea how to write this?
Edited by rhymin, 03 March 2013 - 05:48 PM.