When doing an auto-order Case 1 Min/max = 1/1 SOH = 1 Quantity ordered = 0 Case 2 Min/max = 1/1 SOH = 0.9 Quantity ordered = 1 Case 3 Min/max = 1/1 SOH = 0 Quantity ordered = 1 Case 4 Min/max = 1/1 SOH = -1 Quantity ordered = 2 Case 5 Min/max = 0/0 SOH = -1 Quantity ordered = 0 Case 6 Min/max = 1/5 SOH = 2 Quantity ordered = 0 Case 7 Min/max = 1/5 SOH = 1 Quantity ordered = 4 Case 8 Min/max = 1/5 SOH = 0 Quantity ordered = 5 Queries to set Min/Max Set All Min/Max to 0 Set Min Max to 0 where no sales in a month Search & Replace set by previous months Sales If using SnR to set min/max, when no sales in month chosen min/max get set to 1/1