C
CL
How do I do a spreadsheet where A1 minus A2 is shown in B2 and then be be
able to subtract A3 from A2 and show it in B3? The pattern will continue as
such. It is a fitness program my wife is working on and I'd like to be able
to simplfy it for her.
A1 is starting weight,
A2 is week #2 weight,
B2 is the difference,
A3 is week#3 weight,
B3 is the difference of A2 and A3, etc
The spreadsheet will have 7 input values per week and be used weekly for a
year. If I entered each formula individually I would need to do so over 350
times, which I'd prefer not doing.
I've done spreadsheets before using the fill feature but only for rows or
columns, not for a combo of the 2.
Thanks in advance!!!
Ken
able to subtract A3 from A2 and show it in B3? The pattern will continue as
such. It is a fitness program my wife is working on and I'd like to be able
to simplfy it for her.
A1 is starting weight,
A2 is week #2 weight,
B2 is the difference,
A3 is week#3 weight,
B3 is the difference of A2 and A3, etc
The spreadsheet will have 7 input values per week and be used weekly for a
year. If I entered each formula individually I would need to do so over 350
times, which I'd prefer not doing.
I've done spreadsheets before using the fill feature but only for rows or
columns, not for a combo of the 2.
Thanks in advance!!!
Ken