Results 1 to 3 of 3

Thread: Commission sum of question

  1. #1
    New Member
    Join Date
    Jan 2009
    Posts
    36
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Commission sum of question

    Good morning
    I am creating a spreadsheet that needs the following and I'm having trouble creating this formula.

    I earn commission and I am charged a specific percentage of my sales until I reach a specific sales volume number , say 15% and charged a different percentage once I reach another total sales volume, say 10%.

    For example, once the values of cells H5 to H33 reaches $50,000, I am charged 10% but for anything below $50,000, I'm charged 15%. To complicate matters, I'm still charged the 15% on the first $50,000.

    Any thoughts?

    Thanks
    Craig

  2. #2
    Board Regular arthurbr's Avatar
    Join Date
    Dec 2006
    Location
    Belgium
    Posts
    1,891
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Commission sum of question

    Please,always use a relevant keyword thread title that describes what you are trying to do
    Using XL2003 - 2010

  3. #3
    New Member
    Join Date
    Jan 2009
    Posts
    36
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Commission sum of question

    That was basically what I needed. I needed to make a few changes to it, but works like a charm. Thanks for the help!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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