Results 1 to 5 of 5

Thread: Excel formula for commission bandings

  1. #1
    Neophyte Geordie's Avatar
    Join Date
    Mar 2015
    Location
    Ireland
    Posts
    2
    Articles
    0

    Excel formula for commission bandings



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Can somebody please help me before I go crazy!

    I'm trying to create a formula for commission payments based on bandings above a threshold.

    I've attached an example of the spreadsheet I'm working from, the basics are:

    Revenue less than a threshold of 5k = 0% commission

    Revenue between 5k and up to 11k = 10%

    Revenue above 11k = 15%

    All help much appreciated
    Attached Files Attached Files

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    plz see the file.
    Attached Files Attached Files

  3. #3
    Neophyte Geordie's Avatar
    Join Date
    Mar 2015
    Location
    Ireland
    Posts
    2
    Articles
    0
    Quote Originally Posted by sambit View Post
    plz see the file.
    Hi Thanks for replying but when I open the file it looks corrupt, could you resend please

  4. #4
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    The above file is open my PC. I also try in different PC and it's working. As you want, I have attached another file. please check.
    Attached Files Attached Files

  5. #5
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    Do you mean variable rates

    =SUMPRODUCT(--(E25>{0;5000;11000}), (E25-{0;5000;11000}), {0;0.1;0.05})

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •