I want Excel to calculate inventory on items and keep a running total as items are used.
For example I have 309 cases of Beef patties at the beginning of the week and 10 cases are used on monday and the another 5 are used on wednesday and another 5 ae used on thursday I want to show a running balance as they are used. I tried to set up a formula to do this and the end result always showed value instead of of the balance.
