Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
link a local spreadsheet to a network shared spreadsheet | Setting up and Configuration of Excel | |||
formula to get the spreadsheet address to print on the spreadsheet | Excel Discussion (Misc queries) | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) |