excel 2003

H

Hovik

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
 
D

driller

=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*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top