I have menu items that contain the same inventory ingredients and want to able to deplete that inventory ingredient every time I sell menu items:
- If I have 2 pounds (32 oz.) of meat as an inventory ingredient in cell
- I sell one burrito that contains 8 oz. in cell
- I sell one taco that contains 4 oz. in cell
- I sell one torta that also contains 4 oz. in cell
I want to able to input data in cells
D4 and see the balance result in real time:
A. B. C. D 1. INGREDIENTS. MENU ITEMS 2 meat. 32 Burrito. 1 3. Taco 1 4. torta. 1
B2 contains 32 oz total of ingredient and I'm selling 3 menu items
D4. The burrito contains 8 oz, the taco 4 oz and the torta 4 oz, totaling 16 oz.
I want to make cell
B2 subtract the 16 oz from the sale of the three menu items and show that I have 16 oz remaining.
In general I need to know if you can keep a running balance in one cell.