Hello All
C6 – G6 is Customer demand
C7 –G6 is how man boxes are needed to cover the customer demand
H6 – Maximum Stock holding
Is there a formula that will look at the customer demand in blue and work out what day the maximum stock will need topping up?
Tuesday to Friday uses the maximum stock of 600, so Monday is short of 200 hence the – 10 in G6
Paul
Put this in cell G7 and fill backwards.
Formula:
IF(SUM($C6:F6)>=$H$6,($H$6-SUM($C$6:$G$6))/20,ROUNDUP(G6/20,0))
Also you do with helper. From "I6" To "S6"
In "C7"Formula:=IF(J6>$H6,O6/20,C6/20)
See attach file.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
thanks for the reply ByteMarks
thanks AVK your soloution works how i wanted it to work
Hello AVK
=IF(J6>$H6,O6/20,C6/20)
can a round factor of 20 be put in ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
pmw19800 
Register To Reply
Bookmarks