Tip Printed from ExcelTip.com
Calculate commission percentage based on a commission schedule in Microsoft Excel


The following table is the commission schedule for the example:

$ Sales
% Commission
100
5
250
10
500
15
100
20

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
    •