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.

I figured it Out.....=IF(AND(ISBLANK(A2),ISBLANK(B2)),"",C1+A2-B2)

If you're going to use the AND function, remember that both statements should be TRUE or else it would return FALSE.

The AND operand function works like MULTIPLICATION.

I suggest you use the OR function.
=IF(OR(ISBLANK(A2),ISBLANK(B2)),"",C1+A2-B2)

The OR operand function works like ADDITION.