This is easy do to in paper bud challenging to do in excel

[ragol21]

I have to use only 3 cells to get a balance inventory calculator.

Let's say A1 is for initial inventory amount, C1 for total inventory balance until it show 0, and cell B1 to input every time a new quantity is used from cell A1.

C1 should show the new balance when B1 is input with the new quantity used any given day (day data is not input)

I can not use more rows nor more cells because the are filled with other data.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: This Balance formula is very easy to do in paper challenging in Excel
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.