I have an inventory management file that shows the point where inventory goes to 0.
I usually manually insert the numbers into a column and add those numbers to the current month, in order to have inventory be positive in two months.
I'd rather that I create a formula for this (or maybe a goal seek, but it seems like it would slow my sheet down) that automatically returns the number that would bring march to 0.
Spreadsheet attached.
Bookmarks