Using Excel IF feature can adequately change the commission pace when late payed of discount modifications just how much you are payed of and/or commission pace to pay employees. This feature can change the commission value instantly and could be employed on each of the commission estimates in the file without having modifying any sort of non late sales commissions.
Open the excel document and/or right click the letter of the sales commission excel column. Select insert and rename this excel column payed of on Time. Within this column, you will note regardless of whether a discount was payed of on time. Any value beyond zero represents an on time discount within this file. Write in the sales commission distinctions for on time and late sales. For this particular case, use two % as on time selling and one % like a late discount pace.
Click in the top cell beneath the title in sales commission excel column. You’ll use IF feature right here to find adequate commission quantity. Use the =IF formula to analyze in case the value in payed of on Time excel column is bigger compared to zero and adapt the commission respectively. True that will give the complete commission pace whilst a false return will give you the lowered pace.
For instance, in case the sales result is within column B, payed of on time result is in Column C and commission payed of is within column D, the IF feature for E3 would be =IF without having the quotes. Pick the excel cell with the IF feature and copy it. Paste it in every cell within the commission excel column. Excel would instantly adapt the row numbers to adequately calculate every commission.