Prev: Count function seeing formulas as data
From: MDS1267 on 6 Jun 2010 12:06
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
From: Don Guillett on 6 Jun 2010 12:35
google
excel:checkbook template

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"MDS1267" <MDS1267(a)discussions.microsoft.com> wrote in message
news:C51E15BE-447E-4150-829E-F7B432343220(a)microsoft.com...
>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

From: T. Valko on 6 Jun 2010 12:39
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" <MDS1267(a)discussions.microsoft.com> wrote in message
news:C51E15BE-447E-4150-829E-F7B432343220(a)microsoft.com...
>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


 | 
Pages: 1
Prev: Count function seeing formulas as data