Re-order quantities are based on price. The data in J4:K6 specifies the quantities to re-order for each price bracket, so for example if the item costs from 0 up to (but not including) $300 we re-order 50. In H4 enter a formula that will return the number we need to re-order; this should be 0 if we do not need to re-order. (Note: The values in J4:K6 may be subject to change)

Re-Order Quantities: Item Cost Re-Order Qty $0.00 50

$300.00 25

$1,000.00 10

How to do the calculation in Excel?