Hi!

Will you always enter data in B1, C1 and D1 as a group? If=20
so, you can base your formula on whether or not D1 is=20
empty. In E1 enter:

=3DIF(D1=3D"","",Your_Formula_Here)

With the above, E1 will remain blank until an entry is=20
made in D1.

Biff

-----Original Message-----
Xl2000=20
Been trying to get this right, and I think it is simple=20
but I am not getting=20
it. What I have is: Column B =E2?oamount Rec=E2?Td=E2?=9D,=20
Column C =E2?oPurchases=E2?=9D, Column D=20
=E2?oCash out=E2?=9D, Column E =E2?oBalance=E2?=9D. I am trying to=20
put together a formula in=20
Column E that will only give a result when data is=20
entered into either B, C,=20
or D. Then be able to copy it all the way to row 36, and=20
not have anything=20
in Column E until data is entered into the corresponding=20
row. I know this is=20
easy but I am not getting it. Please Help

Mike R.

.