Help with a checkbook register

[Snoogee]

I made a checkbook register in Excel and am wondering if there is a wa
I can get the ending balance to show only on the last line that has
check entered. The way it is now, the ending balance carries down t
the end of the whole spreadsheet. The register works for me, but th
balance thing is annoying.

I don't know enough about the usage of Excel to know whether this is
formula or what, let alone even begin to figure out how to search fo
this information. Any help would be appreciated. Thank

 

[Guest]

You can use an IF statement to check to see if there is a check in that column and calculate the balance if there is and leave the balance blank if there is no check. For example: IF(C5="","",D5=D4+C5). This should work.

 

[ray]

Hi
Try =if(and(isblank(a2),isblank(b2)),"",c1-b2+a2)
c1=previous balance
a2=withdrawal
b2=deposit
ray