View Single Post
  #1   Report Post  
capt.kash capt.kash is offline
Junior Member
 
Posts: 2
Default Basic Balance Sheet Problem

I have a basic balance sheet. Column A is Credit, Column B is Debit and Column C is Balance. I use formula after first credit line as =C1+A2-B2. The problem is if the balance for e.g is $4000.00 then it will keep repeating the same balance until anything is entered in column A or Column B next to column C. Is there a formula that if Column A or Column B are empty(blank) then column C will remain empty(blank) and the last balance stops at the line when last credit or debit is entered.