| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can update keep an updated balance on a spreadsheet
i have a budget setup in a spreadsheet and i cant figured how to keep a
balance updated on a loan without typing in the new balance everytime |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can update keep an updated balance on a spreadsheet
"bug28" wrote in message
... i have a budget setup in a spreadsheet and i cant figured how to keep a balance updated on a loan without typing in the new balance everytime It's not clear what you are trying to do. Is it something along these lines? Put the initial loan amount in B1. Put each repayment in column A, starting at A2. Put this formula =B1-A2 or this one =IF(A2<"",B1-A2,"") in B2 and drag down column B as far as needed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I update a checkbox as true when another has been updated | Excel Worksheet Functions | |||
| How do I update links from a file that hasn't yet been updated? | Excel Worksheet Functions | |||
| rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
| Chosen not to update links but they are updated anyway. How stop? | Excel Discussion (Misc queries) | |||
| Updated spreadsheet | Excel Discussion (Misc queries) | |||
Linear Mode
