Keeping a Function Cell Blank Until It's Needed

[barry a]

I set up a simple spreadsheet to keep track of my
checkbook balance. The "Balance" column has a formula in
it, "=D2+B3-C3", etc., to create a new balance every time
I enter new deposit or expense data. The problem is that
not only does the new balance appear in the proper cell,
it also appears in every cell below it in the Balance
column. I'd like to know if there's a way to keep these
Balance cells blank until they're needed, which is only
after I enter new deposit or expense data.

Thank you.

 

[Aladin Akyurek]

One way:

=IF(OR(N(B3)>0,N(C3)>0),D2+B3-C3,"")