(which will become starting inventory in that month) and use it to calculate ending inventory of that month, which inturn should be used to calculate prior month's ending inventory of next month, which works well in excel as the formulae there are based on cell values but I am getting ...