View Single Post
  #4   Report Post  
Cutter
 
Posts: n/a
Default


For a running balance in Column C do this

Assume you are putting your first formula in C4 and your carry-over or
starting balance is in C3

=IF(AND(A4="",B4=""),"",C3-A4+B4)

NOTE that you do not put negative numbers in your debit column (A),
otherwise you'll be adding the debits instead of subtracting them.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=472349