I would like to set up a checkbook register in excel. I have a basic idea but
the total column fills before I put an entry in the row.

Hi!

Change your total formula so that it won't show the total
until/unless there are enties in either the debit or
deposit fields. EG:

D2 = debits
E2 = deposits
H2 = total or balance

formula in H2:

=IF(OR(D2="",E2=""),"",Your Total Formula)

Biff

>-----Original Message-----
>I would like to set up a checkbook register in excel. I
have a basic idea but
>the total column fills before I put an entry in the row.
>.
>

Ooops!

Change that to:

=IF(AND(D2="",E2=""),"",Your Total Formula)

Or, you can just choose which ever field you'd like. I
have mine setup to test the first field which is the date.

Here are some tips that I have incorporated into my
register.

I use dropdown lists in most fields so that I'm just
pointing and clicking. I point and click for the date, the
check number, the transaction description, any bank fees
like atm fees, the reconciliation field, and regular
deposit amounts. Basically, all I enter is a debit amount.
Reconciliation is a piece of cake!

Biff

>-----Original Message-----
>Hi!
>
>Change your total formula so that it won't show the total
>until/unless there are enties in either the debit or
>deposit fields. EG:
>
>D2 = debits
>E2 = deposits
>H2 = total or balance
>
>formula in H2:
>
>=IF(OR(D2="",E2=""),"",Your Total Formula)
>
>Biff
>
>>-----Original Message-----
>>I would like to set up a checkbook register in excel. I
>have a basic idea but
>>the total column fills before I put an entry in the row.
>>.
>>
>.
>