I created a balance sheet where column A is date formatted, column B is
general formatted, and columns C & D are both currency formatted. Line one
of the sheet does not contain any formulas, so that the beginning balance can
be adjusted.

My formula starts in cell D2, and is filled down the remainder of column D
in the worksheet. D2 formula is as follows: =IF(ISBLANK(C2),"",D1-C2)
D3 formula reads: =IF(ISBLANK(C3),"",D2-C3)
....and so on down the remainder of column D cells.

The problem is, once data is entered, if a line in the worksheet is deleted,
the following error occurs: #REF! (shows in all column D cells following
the deleted line). When the uppermost error cell is clicked on to review the
formula, the formula shows: =IF(ISBLANK(C3),"",#REF!-C3)
If the subsequent column D cells with the #REF! error are clicked on to
review their formulas, there is no #REF! within those formulas.

Any help is greatly appreciated!

--
Nick B.