BobBridges, I confused myself too, haha. Let's make your description measurements smaller, so I don't confuse you or me. Let's say currently in stock:

Butter has 28 tbsp/box. If 1 box=32 tbsp.
Milk has 23 .5 cups/gallon. If 1 gallon=32 .5 cups.
Eggs has 12 eggs/carton. If 1 carton=18 eggs.

In your example, I will need an to see how many cartons of eggs I need to buy. If calculated correctly, I will need to buy 2 cartons of eggs for the week if I use 5/day with a current stock of 12 eggs. So the cell should say BUY=2.

I'm only calculating from a full box, gallon, carton, etc only. So when calculated in the beginning, I wouldn't have an "in stock" column, but a current full box column.

Hopefully that clears things up.

Edit: I think I got it to work

=IF(Bn<=En*7,"BUY="&ROUNDUP(SUM(SUM(En*7)-Bn)/En,0)),"IN STOCK"))