|  

» 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.42     Views: 51418
    No comments have been submitted.
    Name
    Comment Title
    Comments

    Excel Formula and Function

    Excel Date and Time

    Excel Macros and VBA

    Excel Text, Editing and Format

    Excel General

    Excel Data

    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