N

#### Nick B.

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!