# Any Excel Formula Experts?

#### Bsweeney

##### New Member
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

Thanks!

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
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.

I deleted the duplicate.

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)

1st time posting, sorry for duplicating.

Cell C6 & D6 is a if statement that return a "0' if row 5 is a positive #.

Cell E 6 is D5/E2

Cell C6 & D6 is a if statement that return a "0' if row 5 is a positive #.

So what makes C6 and D6 = to 1? C5 and D5 are both positive numbers?

Correction. below is my revised sheet showing formulas on bottom:

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.

Appreciate the help!

=SUM(IF(\$C\$3:E3>0,1,\$B\$3:D3/\$C\$2:E2))

This needs to be confirmed with control+shift+enter and not just enter.

It can also be copied accross the columns to the other cells.
Book3
ABCDEF
1FebMarAprMayJun
2BudgetedSales222159517957172897623616425465
3EndingInventory1156502793434327547715-21428521-37853986
4
52.26047950.955888
Data

Hope that helps.

Replies
6
Views
613
Replies
1
Views
216
Replies
3
Views
406
Replies
4
Views
147
Replies
3
Views
227

1,196,183
Messages
6,013,914
Members
441,795
Latest member
Lilium

### We've detected that you are using an adblocker.

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.

### Which adblocker are you using?

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

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.
Go back