Hi all, I need to impress the boss with my excel prowess (very limited) and need some help. I have a price list and need to solve for ei ther a % off list price times quantity or set dollar amount times quantity, or both, dependant on the customer. Eg customer wants 10 off 50271 at 40% discount and also 10 off 50270 at $1.10 ea . Not sure weather extra columns with a formula in it or perhaps a drop down box would suit. Bearing in mind quantities ordered must be multiples of 'box qty'
Any thoughts or suggestions greatly appreciated. Chris
|Item no.||Description||Box qty.||Outer Box||Unit||RRP 2011||Trade Price||Discount||NET 2010|
|10||$ 1.10||$ 11.00|