Posts by crimsondriver37

I'll follow up with more details later, I just wanted to see if this was even possible first. I tried playing around with an IF function in Excel, but I think I need something a bit more heavy-duty than that. For example, let's say I have a Cuba Libre cocktail recipe that calls for Coca-Cola, lime, and rum. If I sell two of those cocktails, can an Excel sheet or maybe Access automatically subtract those specific ingredients from my inventory the moment I log the sale?
I'm not quite sure how to explain it better, haha.

Is it even possible to use Excel to manage inventory for a bar? I mean, could you set it up so that when I log a single cocktail, it automatically breaks down all the individual ingredients and subtracts them from my current stock levels?