I'm making a diet plan and I am currently having problems
In one worksheet i have nutrition info (calories/proteins/carbs/fats)
| CAL | PRO | CAR | FAT |
e.g. Pasta | 293 kcal | 13,0 g | 51,0 g | 4,0 g |
etc...
In another worksheet I have a table for total nutrition for the day
e.g. CAL PRO CAR FAT
| | | | |
What i want to be able to do is to write a equation for all the calories i eat
e.g. =('Nutrition Info'!F11*2,5)+...
and then the cells for pro, car and fat will update correspondingly
So far i have been manually updating each of the 4 cells (cal/pro/car/fat), but
since the equations are the same except the letters for the cells (e.g. Calories F11, Proteins G11, Carbs H11)
it would be really nice if i could somehow connect pro, car and fat to mimic the cal equation.
The only thing i've found as an solution is to use auto fill, but still that isn't satisfying as auto fill erases custom endings
(i use kkal for colories and g for pro/cal/fat, after auto fill they all have the custom ending kkal)
I hope I've made myself clear on the problem
Bookmarks