|  

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

CATEGORY - Other Q&A Formulas VERSION - All Microsoft Excel Versions

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
    •  Screenshot // Calculate commission percentage based on a commission schedule in Microsoft Excel
    Calculate commission percentage based on a commission schedule in Microsoft Excel


    Book Store:

    VIEW ALL BOOKS

    Recommended Books:

    Print Tip
    Add to My Tips
    Rate This Tip
    12 34 5
    Rating: 2.59     Views: 33062
    tip
    sara
    i think you should make it easyer for people like me to understand. like people in grade nine
    Click here to post comment
    For Registered Users
    Click here to Regiser
    For Guest
    Name
    Comment Title
    Comments


    Excel 2007 Tutorials


    Terms and Conditions of use

    The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

    Copyright © 2003 ExcelTip.com Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation