+ Reply to Thread
Results 1 to 7 of 7

Increase the pricing by $0.50 - $2 depending on the Base price

  1. #1
    Registered User
    Join Date
    06-18-2009
    Location
    home
    MS-Off Ver
    Excel 2003
    Posts
    11

    Increase the pricing by $0.50 - $2 depending on the Base price

    Column H is the Base price lists

    i want to increase the pricing by $0.50 - $2 depending on the Base price, in column G

    Here is the Base price and increasing to price that i want
    Base price Below $5 = Price increasing to +$0.5
    Base price $10 - $20 = Price increasing to +1.5
    Base price above $20 = Price increasing to +$2



    what is formula or how to do this guys?
    i like this forum, a lot unique stuff here

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Increase the pricing by $0.50 - $2 depending on the Base price

    What happens if it's between $5 and $10?

  3. #3
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Increase the pricing by $0.50 - $2 depending on the Base price

    If it increases by $1 between $5 and $10, then =G1+MAX(4,(INT(G1/5)+1))*.5

  4. #4
    Registered User
    Join Date
    06-18-2009
    Location
    home
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Increase the pricing by $0.50 - $2 depending on the Base price

    ah i am sorry i am wrong, i mean the second line is

    Base price $5 - $20 = Price increasing to +$1.5



    how it is guys? if there is automatically way to do this it will be better too, for example i can change the Base price and the increasing price latter

  5. #5
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Increase the pricing by $0.50 - $2 depending on the Base price

    The only automatic way to do it is to have a table with break points and price increase. If the prices are hard-coded into the formula, the formula will have to be updated with each change. A hard-coded version could be =G1+Lookup(G1,{0;5;20},{.5;1.5;2}) If you have the breakpoints in A1:A3 (low values only) and the increase in B1:B3, then =G1+Lookup(G1,A1:A3,B1:B3)

  6. #6
    Registered User
    Join Date
    06-18-2009
    Location
    home
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Increase the pricing by $0.50 - $2 depending on the Base price

    Quote Originally Posted by darkyam View Post
    If it increases by $1 between $5 and $10, then =G1+MAX(4,(INT(G1/5)+1))*.5
    I want to try formulas like this, what is the formulas for these each :

    Base price Below $5 = Price increasing to +$0.5
    Base price $5 - $20 = Price increasing to +$1.5
    Base price above $20 = Price increasing to +$2

  7. #7
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Increase the pricing by $0.50 - $2 depending on the Base price

    Not really sure what you mean. The formula for each would be something like =G1+IF(G1<5,.5,IF(G1<20,1.5,2)) There's not an easily definable pattern to those numbers and breaks that I can see, but if you want one formula for all, perhaps try =MIN(2,INT((G1+9.99)/15)+0.5)

+ 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