Progressive Tiered Pricing Help

[guyamwell]

Hi Everyone,

I am trying to create a pricing table by year that shows incremental units purchased and their cost. As the individual purchases more units, the unit cost decreases. In the attached example, the first 100 units cost $450 (0-100 units), the next 100 cost $350 (101-200 units), the next 200 units cost $300 (201-400 units), the next 400 units cost $250 (401-800) and finally, 801+ units are $200.

How can I fill in a table that dynamically shows the cost based on the incremental addition of units and show the costs by tranche?

I've attached a file to illustrate the issue.

Any help is appreciated.

Thanks.

[etaf]

i hve changed you pricing table and added an extra line for vlookup to work

then added an if , to work in your tier table

=IF(E$20<101,VLOOKUP(E$20,$B$3:$D$7,3,TRUE),"")

all this does is bring the volume price - it does NOT multiple by the quantity actually ordered
so if happy with the result, then just * volume

=IF(E$20<101,VLOOKUP(E$20,$B$3:$D$7,3,TRUE),"") * E$20
=IF(AND(E$20>100,E$20<201),VLOOKUP(E$20,$B$3:$D$7,3,TRUE),"")

[avk]

Try in "E22"

Please Login or Register  to view this content.

copy paste across.