Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dividing a linear goal
I am trying to chart a weight loss goal and I want to put in a starting
weight and a goal weight in a sheet showing a wieght goal for each day and have excel autofill the equal divisions for the days in between. Is there a function or something that will do this? Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dividing a linear goal
Hi,
Put your starting weight in Pounds in A1 and for a 30 day program put your end weight goal in A30. Then Edit|Fill|Series and ensure Linear is selected and click OK. The intermediate cells will populate with the daily loss requirement. Format the cells as required to get rid of excessive decimal places. Mike "TheNewGuy" wrote: I am trying to chart a weight loss goal and I want to put in a starting weight and a goal weight in a sheet showing a wieght goal for each day and have excel autofill the equal divisions for the days in between. Is there a function or something that will do this? Thanks. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dividing a linear goal
Woohoo. Spot on Mike. Sorted, Thanks
"Mike H" wrote: Hi, Put your starting weight in Pounds in A1 and for a 30 day program put your end weight goal in A30. Then Edit|Fill|Series and ensure Linear is selected and click OK. The intermediate cells will populate with the daily loss requirement. Format the cells as required to get rid of excessive decimal places. Mike "TheNewGuy" wrote: I am trying to chart a weight loss goal and I want to put in a starting weight and a goal weight in a sheet showing a wieght goal for each day and have excel autofill the equal divisions for the days in between. Is there a function or something that will do this? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The multiple regression tool - linear or non-linear regression? | Excel Discussion (Misc queries) | |||
Dividing cells | Excel Discussion (Misc queries) | |||
Dividing name | Excel Worksheet Functions | |||
Dividing by zero | Excel Discussion (Misc queries) | |||
dividing a row | Excel Worksheet Functions |