excel 2003
 

I just made a very simple ledger that has 4 columns( descriptio, debit,
credit and balance) and I am just using one formula in balance column that is
=IF(AND(ISBLANK(D4),ISBLANK(E4)),"",F3-D4+E4)
basically it checks the debit and credit columns(D & E) if they are blank
the balance(F) stays blank, otherwise it calculates the balance every step
away.
sometimes we have more than one debit or credit and we want calculate the
balance at the end of the group of transactions, how can I do that.
Thank You
Hovik

excel 2003
 

=IF(AND(ISBLANK(D4),ISBLANK(E4)),"",F3-D4+E4)
basically it checks the debit and credit columns(D & E) if they are blank
the balance(F) stays blank, otherwise it calculates the balance every step
away.

along column F <balance starting with...
=IF(AND(ISBLANK(D4),ISBLANK(E4)),f3,F3-D4+E4)
copy down to calculate the balance every step away.
the last row will show the calculated balance at the end of the *group of
transactions*
--
regards



"Hovik" wrote:

I just made a very simple ledger that has 4 columns( descriptio, debit,
credit and balance) and I am just using one formula in balance column that is
=IF(AND(ISBLANK(D4),ISBLANK(E4)),"",F3-D4+E4)
basically it checks the debit and credit columns(D & E) if they are blank
the balance(F) stays blank, otherwise it calculates the balance every step
away.
sometimes we have more than one debit or credit and we want calculate the
balance at the end of the group of transactions, how can I do that.
Thank You
Hovik