This might be what your loking for:
If you have your Deposits in A2, withdrawls in B2, adjsutments in C2, and
begining balance in D2, put the following in D3 and copy down:
=IF(OR(A3<0,B3<0,C3<0),D2+A3-B3+C3,"")
To work adjustments have to be entered as negative amounts or positive
amounts.
"Doh" wrote in message
...
Please help, I'm a total Excel newbie. I need to create a spreadsheet that
works pretty much like a checkbook register. I need to be able to make
daily
entries of deposits and withdrawals (dollar amounts) and keep a running
balance. I don't want the balance column to extend all the way down the
worksheet either zero (if that's the current balance) or the most recent
balance . Excel help on "Calculate the running balance" says to "copy this
formula into the current balance cell for each new transaction." Is there
a
way to extend the formula without having to copy and paste it with each
new
transaction? I'll have several identical worksheets for a number of
different
accounts. Btw, I'm using Excel 2000. Thanks in advance for your help.
|