Nobody, I thought I understood this but as I got into the details I decided I need to ask questions first. What would make sense to me is if you have, or want, a worksheet like this:
Code:
A B C D E
1 Description In stock Status Used/day 8 days
2 Butter, lb 28 IN STOCK 3 24
3 Milk, gallon 23 BUY=25 6 48
4 Eggs, 18/carton 12 BUY=28 5 40
5 Sour cream, lb 13 IN STOCK 1 8
With this arrangement (which is what I suspect you're building toward though you haven't spelled it out), you can put in column D how much you figure you sell every day. Column E has a formula "=D
n*8" which calculates how much you should have in stock so as to have one day's stock left over by reorder time next week. (You don't want to have five left over for every item; you want to have more left over of the items that sell faster, right?)
If so, then the formula for column C would look like this:
Code:
=IF(Bn<En,"BUY="&En-Bn,"IN STOCK")
But I made a lot of guesses while I was trying to fill in the blanks in my understanding; I may have filled them in completely wrong.
06-22-2014, 05:58 AM
Similar Threads
if statement
Windows 7 64bit 
Office 2010 32bit
Threaded Mode