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

1. ## 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?  Register To Reply

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

What happens if it's between \$5 and \$10?  Register To Reply

3. ## 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  Register To Reply

4. ## 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  Register To Reply

5. ## 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)  Register To Reply

6. ## Re: Increase the pricing by \$0.50 - \$2 depending on the Base price Originally Posted by darkyam 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  Register To Reply

7. ## 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)  Register To Reply