Hello i want to create a food database as follows:
But in the Food Qty cell i must be able to select another value ex. 230 g and the calories and all other nutritional info would change. How can i do that? I just started learning Excel 2013.
Food Name Food Qty Calories Protein Carbs Fats Milk 0.1% Fat 100 g 31 3.2 4.5 0.1
Thank you.
Bookmarks