Hi All,

Wasn't to sure what to title this with, I would like to apply a discount for multi-qty's orders of Items. More Specifically, for every Six (6) ordered, One (1) Item is Free. So Ordering Twelve (12), would get Two (2) for Free BUT I would like Qty Breaks for 1,2,6 & 12.

1 - £22.00

2 -

6 - ((6 * 22.00) - 22.00)

12 -

What approach do I need to take to creation of a formula AND are there any considerations I should be aware of when quantities increase pass 100 (for example).

Qty 1 - Base Price

Qty 2 - Discounted

Qty 6 - Base for Discount (Order 6, Pay for 5)

Qty 12 - Discounted

Thanks in advance for your advice

Stuart