Use IF function to Calculate the Sales Commission

Consider an Organization which offers Commission to its Sales team based on Sales Amount. The Organization gives Sales Commissions based on below Criteria:

 

 

In Such a Scenario, it is good time to use nested IF() function when we need to calculate a “tiered” payment or Commission. That is, if a certain value is X, you want one result; if the value is Y, you want a second result; and if the value is Z, you want a third result. Refer below working:

 

 

 

 

 

 

 

 

 

If-Function-to-Calculate-Sales-Commission.xlsx (58 downloads)

Kindly share with your friends & give your feedback in Comments:)

1 Comment

Leave a Reply

Your email address will not be published.


*