» Calculate commission percentage based on a commission schedule in Microsoft Excel

The following table is the commission schedule for the example:

Enter the sales value in cell A1: 500

Enter the following formula to calculate the commission percentage:

=IF(A1>1000,20,IF(A1>500,15,IF(A1>250,10,IF(A1>100,5,"No"))))&"%

commission"

The Result - 10% commission
Screenshot // Calculate commission percentage based on a commission schedule in Microsoft Excel

Rate This Tip

Rating: 2.64 Views: 30535

tip

sara

i think you should make it easyer for people like me to understand. like people in grade nine