Question description:
This user has given permission to use the problem statement for this
blog.
I am creating a checkbook register, columnD is deposits, Column E is withdrawal, columnF is balance, how do i get a running total in the balance column
Solved by K. Q. in 16 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
12/02/2018 - 10:08
Welcome to excel got it pro.
Excelchat Expert
12/02/2018 - 10:08
I'm here to help you today.
Excelchat Expert
12/02/2018 - 10:10
My understanding is that, by running total you mean cumulative balance, right?
User
12/02/2018 - 10:10
right
Excelchat Expert
12/02/2018 - 10:11
I have wrote a formula in column F, would you please input some samples in column D and E and test the formula?
Excelchat Expert
12/02/2018 - 10:12
Is it alright?
User
12/02/2018 - 10:12
yes
Excelchat Expert
12/02/2018 - 10:14
you have the formulas?
User
12/02/2018 - 10:14
where are they?
Excelchat Expert
12/02/2018 - 10:14
this is for first row =D2-E2
Excelchat Expert
12/02/2018 - 10:15
From 2nd row use this =F2+D3-E3.
Excelchat Expert
12/02/2018 - 10:15
[Uploaded an Excel file]
Excelchat Expert
12/02/2018 - 10:15
This is a copy of the preview file.
User
12/02/2018 - 10:16
Do I have to keep writing in a formula
Excelchat Expert
12/02/2018 - 10:16
You can drag the formula down.
Excelchat Expert
12/02/2018 - 10:17
Like this.
Excelchat Expert
12/02/2018 - 10:17
Do you want me to modify the formula so that when col D and E both are blank, F will also be blank?
User
12/02/2018 - 10:18
Can you show me how to drag it again
Excelchat Expert
12/02/2018 - 10:19
Sure.
Excelchat Expert
12/02/2018 - 10:21
So, when you select a cell in excel, do you see a rectangle at the bottom right corner of that cells border? move your mouse pointer over it, you will then see your mouse pointer making a plus sign, now hold it and drag it down.
User
12/02/2018 - 10:21
yes and ok
User
12/02/2018 - 10:22
So I won't have to keep writing a formula in the balance column
Excelchat Expert
12/02/2018 - 10:22
Yup.
Excelchat Expert
12/02/2018 - 10:22
That's true.
User
12/02/2018 - 10:23
Thanks now I hope it will work when I create my register
Excelchat Expert
12/02/2018 - 10:23
[Uploaded an Excel file]
Excelchat Expert
12/02/2018 - 10:23
It sure will, please keep the file for reference.
Excelchat Expert
12/02/2018 - 10:24
Anything else you need?
User
12/02/2018 - 10:24
ok and thanke
Excelchat Expert
12/02/2018 - 10:24
If not please close the session and leave a feedback for me.
Excelchat Expert
12/02/2018 - 10:24
To close session click on the end session button.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
