Complex formula (to me) & don't know where to begin

Originally Posted by judgeh59

okay....my bad....that's what I get for 2 things at once....sorry about that....you are correct that your OHI will drop to 52 at the end April and you'll have to order but the next calculation has to come from the new OHI of 52 not the OHI of 400 so you have to keep a running OHI to do the calculation....so it is very possible that MelvinRobbs formula will work, just be a where of the running OHI

Ahhh, ok I see what I did wrong because I wasn't using the current OHI. So now when my requirements plus inventory don't exceed 400 it shows as -400. If it is negative I wouldn't need to order then. How would you edit the formula to say if it is negative make 0?