| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I create a running balance?
I am finding it extremely diffucult to have a running balance, G column is
the running total, anything in E column is to be subtracted from G column and anything in F column is to be added to the G column total. So G-E+F=G Does this make sense and how in blazers do you write the formula so it does? I am tearin my hair out!!!! Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I create a running balance?
I assume your running total is running down the column (G). So, you need to
start with the previous value of G (from the row above), subtract E, and add F to get the new total. In G6 (for example), your formula might be: =G5-E6+F6 You can copy this formula down column G to keep a running total. Hope this helps, Hutch "Kate" wrote: I am finding it extremely diffucult to have a running balance, G column is the running total, anything in E column is to be subtracted from G column and anything in F column is to be added to the G column total. So G-E+F=G Does this make sense and how in blazers do you write the formula so it does? I am tearin my hair out!!!! Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| running balance | New Users to Excel | |||
| Running balance!!!...? | Excel Worksheet Functions | |||
| How do I create a running total (balance) in a pivot table? | Excel Worksheet Functions | |||
| rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
| how do i create a running balance on checkbook register | Excel Discussion (Misc queries) | |||
Linear Mode
