I hope someone can help, I have a Liquor inventory for my pub that I want to set up an ordering cell that looks at what I have on hand versus my par level and gives me an order amount. Example: If I have 1.4 kegs on hand and my par is 2, I want to order 1 (Anything 1.5-2 order 0, Anything from 1-1.4 I want to order 1, Anything from 0.9 - 0 I want to order 2) How do I write the formula. Assume my on hand is cell G20 and my Par Level is M20 and my Order cell is N20. Please help, Thanks alot.