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?

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

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

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

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

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)

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

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)

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

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