need help making a formula

Discussion in 'Excel Worksheets' started by kath, Mar 4, 2008.

  1. kath

    kath Guest

    i need to make a formula that will show a commission rate of 5% sales over
    15,000 with a 3% sales commission for lesser sales. Could someone please
    help me with this.
     
    kath, Mar 4, 2008
    #1
    1. Advertisements

  2. kath

    Ron Coderre Guest

    A1: (a sales amount)

    B1: =A1*.03+MAX(A1-15000,0)*.02

    Is that something you can work with?
    --------------------------

    Regards,

    Ron
    Microsoft MVP (Excel)
    (XL2003, Win XP)
     
    Ron Coderre, Mar 4, 2008
    #2
    1. Advertisements

  3. kath

    Ron Coderre Guest

    Actually, if you use what I posted, it will fix itself.

    This:
    B1: =A1*.03+MAX(A1-15000,0)*.02

    will become this:
    B1: =A1*0.03+MAX(A1-15000,0)*0.02

    (zeros preceding the decimal points)

    --------------------------

    Regards,

    Ron
    Microsoft MVP (Excel)
    (XL2003, Win XP)
     
    Ron Coderre, Mar 4, 2008
    #3
  4. kath

    T. Valko Guest

    Does that mean if the sales were 27,336 -

    3% of the first 15,000 + 5% of the next 12,336 ?

    If that's the case:

    A1 = 27,336

    =IF(A1="",0,MIN(A1,15000)*0.03+MAX(A1-15000,0)*0.05)

    Commisson = 1066.80
     
    T. Valko, Mar 4, 2008
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.