blank cells with formulas

I created a spreadsheet in which I have extended formulas to blank cells so that when I input data daily it will add/subtract as necessary, but how do I get the cells to remain empty until I fill them, such as in a check register. It has the formula there, but the next line doesnt calculate until you input the data. I have attached the sheet, and I want the cells from April 5th down to be blank, like a check register, but they are filling in info already.

Hi,

Just wrap each of your formulae in columns C & D formulae with an =IF() test. e.g. in C5

Please Login or Register  to view this content.

repeat similarly in D5 and copy both down.

Regards

wonderful! that worked wonderfully for column 'C', however, how do I get all the formulae in column 'D' to start with the same cell? when I copy down it always changes to the next cell in line, I want each cell to always subtract or add from cell (B2). As of now, I copied your formulae, and I am manually changing each cell to reference back to cell (B2); ie: =IF(B4="","",SUM(B4)-(B2))
thanks so much Richard!

Hi,

Just make the cell reference absolute by prefacing with a $ sign. i.e.

Please Login or Register  to view this content.

Rgds