IF/THEN Statements for Data Range

[Horatius7]

So here is some data:Attachment 536225

What's happening is there is an inventory quantity in the 'Last Inv.' column. In columns M-Q I have the future ship dates along with the quantity of each part that will be shipped. (20 systems will be shipped each week, so I accumulate the running sum in each week. Example: 20 shipped on 9/1 = 20; 20 more shipped on 9/8 = 40 etc.)

Now there's only a certain amount of inventory, again, 'Last Inv.', and I want an equation that will look at the values in the coming weeks and when the total exceeds the qty I have in inventory, I'd like for the corresponding DATE to be put in "Date of Depletion" column.

For example: Blocks have a Date of Depletion on 29-Sep because 100>85.

Anyone know what equation I could use?

Thanks!!

[alansidman]

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Horatius7]

Ok, thank you for the advice. The file is uploaded