Hi, I'm hoping to get some help in the creating a formula.
My challenge is in my existing workbook i have a current list of all the ingredience i have in stock. I also have a reciepe for a number of products I am making and the amount of ingredience each product requires.
i.e. Ingredience. A i have 10 units, b i have 5 units Reciepe for Product 1 = A 6 units, B 3 units. Produt 2 = A 5 units , B 2 units. Product 3 = A 3 units, B 4 units and so on.
What I want calaculate is, 1. do i have enough ingredience to make a number of products at the same time (say 1,2 and 3)
2. if not what ingredience don't i have enough of.
Thnx in advance.
Bookmarks