In column a I have the percentages, column be is a dollar value. In column c, I want to create a formula to multiple the b column by a percentage based on the percentage value in column a. If an employee hits the percentage mark for a given period then they receive the commission percentage associated the range listed below.
Example
If less than 40% in column a, then multiple value in column b by 15%
If between 40-49.9% in column a, then multiple value in column b by 20%
If between 50-59.9% in column a, then multiple value in column b by 25%
If between 60-69.9% in column a, then multiple value in column b by 30%
Example
If less than 40% in column a, then multiple value in column b by 15%
If between 40-49.9% in column a, then multiple value in column b by 20%
If between 50-59.9% in column a, then multiple value in column b by 25%
If between 60-69.9% in column a, then multiple value in column b by 30%