HI-I NEED A FORMULA THAT WILL CALCULATE THE FOLLOWING COMMISSIONS FOR EACH LINE...
If sales are 5,000,000 to 6,000,000 = 2.5%
If sales are 6,000,000 to 6,500,000 = 3.0%
If sales are 6,500,000 to 7,000,000 = 3.5%
If sales are 7,000,000+ = 4%
PLEASE HELP
If sales are 5,000,000 to 6,000,000 = 2.5%
If sales are 6,000,000 to 6,500,000 = 3.0%
If sales are 6,500,000 to 7,000,000 = 3.5%
If sales are 7,000,000+ = 4%
PLEASE HELP