running balance in excel 07

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

dak401

Thread Starter
Joined
Apr 5, 2010
Messages
2
Hello,
ok here is my problem. i'm trying to set up a simple ledger with a running balance and i have got to the running balance and all totals are working but the problem is the in the balance column it has the balance in all the cells. what i'm looking for is to not have the balance in the balance column untill there is and entry in either the credit or the debit column. i'll attach it so that maybe it will be a little more self explaining. i have played around with the "IF" funtion but i'm not real familure with excel and still really learning it.

Thx for any help :)
 

Attachments

Joined
Jul 4, 2008
Messages
285
I am by no means an authority of MS Excel, but I did have a similar question as yours some time back and one of the folks at this site helped me with this answer. Hopefully it will help with your situation.
Enter in Balance cell E4 the formula below, click and drag on down.
=if(and(isblank(c4),isblank(d4)),"",e3+c4-d4)
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top