How to Calculate Commission in Excel?, calculate commissions, commissions, commissions payment, if statement, microsoft excel, excel, functions, if we learn how to bring out commission in excel then we can make any sheet for office. This will be very helpful for marketing management people. Team leaders, MIS operators etc. How to Calculate Commission in Excel? To do this we will use a table which will contain 5 headings in columns i.e. Name Basic Salary Sales Amount Commission Total Pay Now we will use Nested IF to calculate COMMISSION Commission Calculation Criteria are as Follows: Sales Amount is Less than 150000 then 10% Sales Amount is Greater than or Equal to 150000 and less than 350000 then 15% Sales Amount is Greater than 350000 then 20% Now As per the Template we will use the following formula to calculate commission: =IF(D6<150000,D6*10%, IF(D6>=150000,D6*15%,IF(D6>35000,D6*20%))) And all Done. Drag the formula down and we will get the result in every cell.