| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i keep a running balance in excel?
|
|
#2
|
|||
|
|||
|
Assuming column A is where you enter the data, in B1 enter =A1
In B2 enter =IF(A2="","",B1+A2) Drag/copy down as far as you think will need, depending upon the expected data range in column A. If, by "running balance" you mean accumulate in one cell, there are ways to do that, but you will have no "paper trail" for checking entries. Gord Dibben Excel MVP On Mon, 26 Sep 2005 18:25:03 -0700, regi k wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| with new print server, excel running slow intermittently | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
| Excel files on local drives running from internet | Excel Worksheet Functions | |||
Linear Mode
