![]() ![]() If this is possible, how could I pull this off? I have no idea if this is even possible with spreadsheets, but I have this idea in my mind that if I could only "teach" the cells the values of 100g of each Ingredient, I could somehow get Numbers to do the math and automatically change those values to reflect other gram amounts. But I would like the values of the Calories, Fat, Carbohydrates, and Protein to change correspondingly when I input a different Amount of the Ingredient in grams.įor example, if I were to change the Amount (g) of Dry Yeast from 4 to 10g, I would like the corresponding Calories, Fat, Carbs, and Protein to change accordingly. These are the nutrition facts of some bread I made. Numbers - Nutrition Input Help Hi, Apple Community! I need some help with Numbers regarding the input of my nutritional data. Excel's "data validation" adds them to its "pop-up" without me having to do anything additional. ![]() You just type them in and sort the table. I started this with Numbers but have been using Excel instead because it is easier to add new foods to the list. Select one of the "-" popups and copy/paste it into all of column A in the "Blank" sheet.Select all of column A except the header cell and format as a pop up.If you have a recipe from another sheet to be added to the list, go to that sheet and copy/paste the values from row 2 vs typing them in. Type in your new foods and their values in rows at the bottom.Select column A of the "Food Items" and set the cell format to Text.To put new foods on the list in the first sheet, Other sheets are examples of "recipes" and daily intake. You duplicate this sheet when you want to make a new recipe or add up a day of food. Second sheet ("Blank") is a blank table already set up with the pop up menu in column A and all the formulas. ![]() First sheet ("Food Items") is the list of food items like Wayne was showing. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |