Hmmm try this
Put in I10
Formula:
=IF(COLUMNS($I$6:I6)>6,IF(OFFSET(I9,,-$C$9)>0,H7-I8-SUM(B9:F9),0),0)
fill right
sorry just read the comment
Based on assumption this is physical fresh stock with 6 days life left on
this is how the formula was constructed, if this changes or requires change....you need to alter the outer IF statement accordingly
Last edited by humdingaling; 09-28-2018 at 12:41 AM. Reason: read comment in file
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks