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.
|