Hi all,
I'm working on a bar inventory. I'm happy with the sheet thus far, but am open to ideas about the general structure if you have them.

I'm trying to do extension costs on keg beer, bottle beer and wine (haven't decided how to handle liquor - shot vs pour).
Essentially what I want to express is cost/item (bottle, pint, glass of wine).
Example, if we purchase a case (24) of Stag beer for $16.15 what is the cost/bottle. (Simply math I realize)
Another example, if we purchase a keg (5.16gal, 661oz) for $39 what is the cost/pint (16oz).
As you can see, I have created a simple table (a model of the real one) and would like to create a formula that recognizes IF E2:keg and IF F2:1/6b THEN divide 661/16/G2(cost)
OR IF E2:cs/24 THEN divide 24/G2(cost).

So I need to associate 1/6 with 661, and 750ml to 25.36. And train Excel to know that 'cs/12' or 'cs/24' means 12 or 24 bottles.

Can anyone help? Hope so.

Thanks a lot

BenExampleInven.xlsx