If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Checkbook calculations
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 |
#2
|
|||
|
|||
Checkbook calculations
google
excel:checkbook template -- Don Guillett Microsoft MVP Excel SalesAid Software "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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|