running balances
 

Hello. I am confused as to how to get a checkbook running balance in
2003 excel. The help topic only made the confusion worse.

Cell D4 is the starting previous eom balance, then each row starting in
cell C5 would reflect written check amounts or deposits, by way of
currency formatting for one or the other as perferred. Column D on down
each row should end with a running balance for each row. I want to be
able to start with a previous balance and continue inputing sums but
that isn't happening. Just not sure where to go from there as none of
the formulas I've tried will work. Maybe formatting for the style of
currency I wanted to use is the problem. Could someone please help with
this? Thank you.


--
lil'bit

married, muddled, and mistook
------------------------------------------------------------------------
lil'bit's Profile: http://www.excelforum.com/member.php...fo&userid=4306
View this thread: http://www.excelforum.com/showthread...hreadid=540512

running balances
 

Put this formula in cell D5:
= D4 - C5
and simply drag/extend it down the page. You have not allowed for deposits,
but you can handle them in this simple format by entering them as negative
values.

Or if you put deposits in Column B, you could change the formula for D5 to:
= D4 + B5 - C5

If you want to just use column C for both deposits and debits and enter them
in more standard form, in cell D5 enter
= D4 + C5
and enter all checks and service charges and such as negative numbers, and
deposits as positive values.

"lil'bit" wrote:


Hello. I am confused as to how to get a checkbook running balance in
2003 excel. The help topic only made the confusion worse.

Cell D4 is the starting previous eom balance, then each row starting in
cell C5 would reflect written check amounts or deposits, by way of
currency formatting for one or the other as perferred. Column D on down
each row should end with a running balance for each row. I want to be
able to start with a previous balance and continue inputing sums but
that isn't happening. Just not sure where to go from there as none of
the formulas I've tried will work. Maybe formatting for the style of
currency I wanted to use is the problem. Could someone please help with
this? Thank you.


--
lil'bit

married, muddled, and mistook
------------------------------------------------------------------------
lil'bit's Profile: http://www.excelforum.com/member.php...fo&userid=4306
View this thread: http://www.excelforum.com/showthread...hreadid=540512

running balances
 

Thank you for the help. It's very appreciated.

Tried the first formula you gave and it works fine for me. :)


--
lil'bit

married, muddled, and mistook
------------------------------------------------------------------------
lil'bit's Profile: http://www.excelforum.com/member.php...fo&userid=4306
View this thread: http://www.excelforum.com/showthread...hreadid=540512

running balances
 

Glad it worked for you. You're certainly welcome.

"lil'bit" wrote:


Thank you for the help. It's very appreciated.

Tried the first formula you gave and it works fine for me. :)


--
lil'bit

married, muddled, and mistook
------------------------------------------------------------------------
lil'bit's Profile: http://www.excelforum.com/member.php...fo&userid=4306
View this thread: http://www.excelforum.com/showthread...hreadid=540512