View Single Post
  #3  
Old June 6th, 2010, 05:39 PM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default Checkbook calculations

Here's how I have mine setup:

Row 1 = column headers
A1 = Date
B1 = Ck Num
C1 = Description
D1 = Debit
E1 = Rec (reconcile)
F1 = Fee
G1 = Deposit
H1 = Balance

H2 = starting balance (manually entered)

Enter this formula in H3 and copy down:

=IF(A3="","",SUM(H2,G3)-SUM(D3,F3))


--
Biff
Microsoft Excel MVP


"MDS1267" wrote in message
...
I am trying to create an Excel worksheet to calculate my checkbook. I want
to
be able to enter different transactions and have them added or subtracted
from my balance, as well as keep a running balance. Any info will be most
helpful.
Thank you