ive got a pretty simple scenario,
lets say cost of product X = $100
buy up to 2 = %10 off = $90
buy 3-5 = 15% off = $85
buy 6-9 =20% off = $80
buy 10 or more = 25% off = $75
if someone buys 7 products, the formula should calculate:
(2*90) + (3*85)+(2*80) = $595.
Can someone help me put...