If cell contains value, subtract from multiple cells

[PreppieCrown]

Hi guys,

I'm relatively new to Excel and need to use it for a uni assignment. Basically, I'm testing out the economy of a cafe simulator game, checking to see if the values of ingredients are appropriate for players to complete a level.

The orders that arrive are randomly generated, and I have that set up. The numbers generated correlate to a customer order. For eg: 1 = Bacon and Eggs.

What I want to do is to check if the cell either says "1", "2", or "3" and take away a quantity. For example, if 1 has been randomly generated, take away 2 from two seperate cells that correlate to an ingredients list.
So:
The customer has ordered Bacon and Eggs (1) and I need to take away 2 Bacon and 2 Eggs from ingredients.

I'm also not entirely sure on where to put the formula or potential formulas for it to work effectively.

I've tried the If formula, and Countif and none of them seem to do what I want, I could just be doing it entirely wrong though.

[mehmetcik]

LOL.

Take this One Stage at a time.

First you need a row or column where you list your stock. So Lets assume Row 1 is used for titles, Row 2 is your initial stock.
Keep Row 3 spare for your formula to count the used ingredients. =sum(B5:B2000)
Row 4 = Row2 - Row3 present stock level.

So Maybe you start the day with 200 Rashers of Bacon, 36 Eggs, 48 Slices of Bread.

Under Eggs you will need a formula to calculate the number of eggs used.

so in Column A a 1 means Bacon & Eggs. Maybe 2 means Spanish Omelette, ie 3 eggs

=IF(A5="","",CHOOSE(A5,2,3,4,5,7,8))

This formula will return 2 if A4 =1 or 3 if A4 =2