View Full Version : Excel Help


James_JJK
February 6th, 2004, 07:50 PM
Alright, I completed my Excel meal planner setup. I filled in all the numbers for everyone. I'm now left to do

Totals
Percentages
Targets
Difference

I figured out how to do totals, you just click on the box under all the nubmer boxes and click the icon at top do to AutoSum. You click that icon 2 times and its set, it adds it all up. I don't know how to do the others... Any help, like a walk through please. Thanks

daveo
February 6th, 2004, 10:02 PM
Alright, I completed my Excel meal planner setup. I filled in all the numbers for everyone. I'm now left to do

Totals
Percentages
Targets
Difference

I figured out how to do totals, you just click on the box under all the nubmer boxes and click the icon at top do to AutoSum. You click that icon 2 times and its set, it adds it all up. I don't know how to do the others... Any help, like a walk through please. Maybe it would help if I told you this: Excel's magical word for "this is a formula" is '='.

As an example, you have a cell (A15) with the target that you typed in. You have a series of cells (A1 - A14) with all your entries. To see the total you could do as you described, or in A16 type '=sum(A1:A14)'
To get a percentage (e.g. if A16 (the sum) is your total calories and B16 is your total fat calories) you could simply type in B17 '=B16/A16'. Get it? To make it look nicer you'd want to format the cell (Cell Formatting) and make it a 'Percentage' instead of a 'General'.

Differences are just subtraction '=A16-A15', etc.

Does that help? PM me if you need more assistance.