Checkbook Formula

[J Hatz]

Hello,

I am trying to set up a checkbook register on my computer with excel. I
don't have any experience with excel and formulas and was wondering if
someone could help me.

I have a column for withdraw (subtraction) and deposits (addition) but in
the balance column, I want it to differentiate between the addition and
subtraction column is that makes sense.

Any help is appreciated.

Thank you in advance,

J Hatz

 

[Paul B]

J, there is one here to look at
http://office.microsoft.com/search/results.aspx?Scope=TC&Query=checkbook&CTT=6&Origin=EC010331121033

I also have one set up, if you would like to take a look at it let me know

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[J Hatz]

That is what I needed. Thank you so much. Saves me the long way of
programming it myself. Thank you!

 

[David McRitchie]

I was unable to complete the download and test example from the Microsoft
site last night; whereas, I see the poster succeeded and was happy with the
result. Anyway you might take a look at an example of a check register in
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
The main point is that it allows you to insert and delete rows between
rows at a later time as well as at the bottom. This is not a template.
The use of OFFSET is critical to this ability.

 

[Paul B]

You're welcome, and the feedback is appreciated

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Using Excel 2000 & 97
** remove news from my email address to reply by email **