+ Reply to Thread
Results 1 to 4 of 4

commission function

  1. #1
    Registered User
    Join Date
    06-15-2008
    Posts
    11

    commission function

    I'd really appreciate any help I could get with this. I though I had it a few hours ago, but now I'm googly-eyed, can't think straight, and actually managed to revert back from a function that worker partially to one that doesn't work at all.

    At the point where I had half of the formula working, I could continue no further because I received an error message like "too many arguments in this cell". Following is the commission schedule I would like to create function/formula for so all I will have to do in the end is input the gross for the month and get the correct value:

    if gross is between:

    0-$12,500 - commission is 3%
    12,501-15000 - commission is 4%
    15,001-17,500 - commission is 5%
    17,501-20,000 - commission is 6%
    20,001-22,500 - commission is 6.25%
    22,501-25,000 - commission is 6.5%
    25,001-∞ - commission is 6.75%

    this is what is left of the butchered work I've been wasting the last several hours trying to get to work ... again, any help would be appreciated.

    =IF(C8<=12500,(C8*0.03),IF(C8>=12501),AND(C8<=15000,(C8*0.04))

    Thanks in advance.

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    G'day and welcome


    Try this

    copy and paste

    Please Login or Register  to view this content.

    Hope this helps
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  3. #3
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    Sorry for the bump in this thread.


    I found a typo in the formula please use this one

    Please Login or Register  to view this content.
    I had missed a zero on the end of the 15,000. The commission of 4%.

  4. #4
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    Sorry again one of those days,

    Well I double check and double check when time was available.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1