Solved Running Balance in Excel

February 7, 2017 at 12:07:21
Specs: Windows 10
I am trying to do a running balance. Here is how I have my excel sheet -
CELL C CELL D CELL E CELL F
Beginning Deposits Withdrawl Balance
$2,918.46 $0 $0 $2,918.46
$2,918.46 $400.00 $0 $3,318.46
$3,318.46 $0 $460.00 $2,858.46
$2,858.46 $1,000 $0 $3,858.46
$3,858.46

So I want it do two things. Sum the balance an minus if any withdrawals and then throw the new beginning balance into Cell D from Cell F and continuing.

message edited by bhmhrex


See More: Running Balance in Excel

Report •

#1
February 7, 2017 at 12:42:13
First, a posting tip:

Please click on the blue line at the end of this post and read the instructions on how to format example data so that it is easier for us to read. Then edit/repost your data so that the columns line up correctly. Don't forget to use Column letters and Row numbers as shown in the example.

Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 7, 2017 at 12:50:01
It looks like your doing a Check Register.
There are lots of free templates on the web that do just that.

Here are just a few:

https://templates.office.com/en-us/...
and
https://www.vertex42.com/ExcelTempl...
and
https://www.spreadsheet123.com/Exce...

MIKE

http://www.skeptic.com/


Report •

#3
February 7, 2017 at 13:01:09
✔ Best Answer
To answer your question, with your data like this:

       A            B            C              D
1) Beginning     Deposits    Withdrawl       Balance
2) $2,918.46          $0            $0      $2,918.46 
3) $2,918.46     $400.00            $0      $3,318.46 
4) $3,318.46          $0       $460.00      $2,858.46 
5) $2,858.46      $1,000            $0      $3,858.46 
6) $3,858.46                 

The simplest way is to enter this formula in BOTH
cells D2 & A3 then drag down.

=A2+B2-C2

See how that works for you.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question