I am tying to create a price list, I have the following data.
QTY Cost Design Sell 250 £17.08 £10.00 £32.71 500 £20.39 £10.50 £37.61 1000 £24.40 £11.03 £43.48 2500 £33.67 £12.16 £56.94 5000 £50.69 £12.76 £80.18
QTY - The quantity of prints
Cost - The cost of the prints
Design - Cost of design
Sell -(1.33 is the markup on the print)Please Login or Register to view this content.
Now the design price increases incrementally, with the base quantity being the base design price and each increment coumpunding by (in this example) 5%.
Would I be able to do this increment automatically, using a formula, with the quantity column as the reference?
So something like, if QTY is ranked the lowest value, then design price is the base, and with each incremental quantity, increase design price by 5%.
Bookmarks