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
Can you tell us how you are manually calculating E7? All you are giving us is numbers and expect us to know what goes together? You should also have stuck to your original thread.
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)
Ok now that makes a lot more sense, so let me make sure I am understanding you correctly, you want to get rid of the formulas in C4, D4 and E4 and only have the formula in E5?
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.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.