I am trying to calculate Inventory Months Supply.
I can calculate the months suppply as shown below in multiple cells, but I am looking for a formula to do in one cell..
The correct result in this example is: 2.26048
In the future, please do not post duplicate threads. All follow-ups, clarifications, or bumps should be posted to the original thread. Per forum rules, all duplicates will be locked or deleted (http://www.mrexcel.com/forum/showthread.php?t=127080 , rules 21-23)
Yes, That would be perfect if that could be done. The formula would actually have to cover a 12 month span of budgetd sales. In this example I knew that it was just over 2 months, but it just as easily be 11 months.