running balance in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to put the equivelant of the "WilsonJones" 2 column green ledger
sheet on excel for a running balance. My columns will be (A) Date, (B)
Patient Name, (C) Date of Service, (D) Write Off Amount, and (E) Balance. So
my first line entry of $10.00, D and E will be the same, $10.00. When I type
on line 2 the write off amount of $15.00, I want column E to automatically
read the balance of $25.00 and so on. Is this possible?
 
one way:

E1: =IF(D1,D1,"")
E2: =IF(D2,E1+D2,"")

Copy E2 down as far as required.
 

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

Access Running Balance in Access 1
running balance 10
Running Total, Opening & Closing Acct Balance in Cash Book 1
How can cell entries be based on word entries in another cell ? 1
The If function 4
Excel SUMIF formula statisfying two conditions 8
excel 2003 1
Running Balance (Debit and Credit) in Access 2007 4

Back
Top