Numbers formula needed please!

Discussion in 'Mac Basics and Help' started by AndoverV, Nov 9, 2010.

  1. AndoverV macrumors newbie

    Joined:
    Nov 9, 2010
    Location:
    MN
    #1
    I need a formula that has a graduated rate of percentage added???

    for instance if 1-300 orders are made, then 10% bonus
    if 301-600 orders, then 12% bonus
    if 601-900 orders, then 14% bonus...and so on.

    then i need them all added together.

    i do not want the original 300 to have higher than a 10% bonus.

    so example

    300 orders at 10 dollars x 10% = $300
    orders 301-450 at 10 dollars x 12 = $180

    total bonus = $480.

    please help...
     
  2. lucifiel, Nov 9, 2010
    Last edited: Nov 9, 2010

    lucifiel macrumors 6502a

    lucifiel

    Joined:
    Nov 7, 2009
    Location:
    In your basement
    #2
    I can do it via excel if you want me to?

    post up an .xls sheet?

    Actually, I've done it up to 2400, how high do you need the brackets to go? Excel won't let me nest any more IF functions in.


    here you go:

    http://dl.dropbox.com/u/9094848/Example.xls
     

Share This Page