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