Forum Discussion
Ingredients calculator
Good Morning,
hoping someone can help.
I want to creat a formula which works out if I need to make 1 pizza it then can work out the sum of how much cheese I will need.
so if I need 70grams of cheese per pizza and I enter on my sheet that I will make 10 pizza it will then make the calculation of how much cheese I will need for 10 pizza’s
obviously I can then scale this to work with other toppings. Ideally I’m looking for the end figure to be in grams but could also be in KG if that’s easier.
Any help would be incredible.
Many thanks!
10 Replies
This simple setup allows you to quickly calculate how much of any ingredient you’ll need based on the number of pizzas you’re making. It’s quite efficient, and you can add any additional rows for other toppings or ingredients as needed.
You can also use Excel's features so that you do not have to enter the number of pizzas for each ingredient for a type of pizza.
See the attached workbook. Use the dropdown list in cell A2 to select a food item. The formulas in cells C4 through E4 select (filter) data from the Ingredient Lists worksheet, using Excel's FILTER function. The formula that calculates all the quantities for a food item is the most complicated; it is in cell D4:=IF( $A$2="", "", FILTER( 'Ingredient Lists'!E$2:E$1000, 'Ingredient Lists'!$C$2:$C$1000 = $A$2, "recipe not found" ) * $B$2 )(Most of the spaces in those formulas are not needed, but make the formulas somewhat easier to read.)
The ingredient quantities that I included are made up, and of course, do not include the dough, oil, etc. But you can change those quantities and include rows for other ingredients and for other food items. Blank rows are not required between the food items, but they make it easier to review.
With a few changes to the workbook, you could also include recipes or other notes for each food item.
That example should get you started. Feel free to ask follow-up questions.Hi Lewis, I appreciate the spreadsheet! I have a question is there a way to enter multiple recipes to get the total amount of each ingredients to know much ingredients total for those recipes to order/purchase. Example: Cookies- 2 cups of chocolate chips, 1 cup of butter, Truffles-3 cups of chocolate chips, 1/2 cup of butter. For this order I need to purchase 5 cups of chocolate chips and 1 1/2 cups of butter. I would really appreciate the help instead of manually added up the total amount of ingredients to purchase each time I get a different orders.
(This is Snowman55, not Lewis.)
If you are using Excel 365 or Excel for the web, the workbook attached to this reply has one solution, and additional information for you on the _Info worksheet.
