I need to maintain my daily food intake at a 40/40/20 (fat/protein/carb) ratio. I keep a daily journal of what I eat each day listing the fat, protein and carb amounts of each food. Then I have a grand total for the day.
What formula will tell me the daily ratio of 40/40/20 of fat, protein and carbs? I am quite the newb and apologize for not stating the question well. I use Excel 2003 and Windows 7.
Thanks for any light you can shed.
Hello & Welcome to the Board,
Is it possible you could post a small sample worksheet with what you expect and how your sheet is laid out?
This will help as there could be different ways to get where you want to go?
HTH
Regards, Jeff
Suppose you have your total daily amounts of fat/protein/carb in say A1 B1 and C1, entering in A2will give you the % fat.Then drag the formula to B2 and C2 to get the other percentages
Please Login or Register to view this content.
Format all 3 cells as %
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks