Excel Worksheet

[Mike Pirolli]

How do I get the formula, that will allow my spreadsheet to work like a bankbook. to subtract and add the debits and credits and give me the balance in another colume.

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Mike H]

Mike,

there are hundreds of templates available to do this. have a looke here for
a start

http://office.microsoft.com/en-us/templates/results.aspx?qu=personal+finance&av=TPL000

Mike

 

[Shane Devenshire]

Hi,

Suppose you enter credits in column A and debits in column B and both start
on row 2. In C2 enter the following formula

A2-B2

in C3 enter

=IF(COUNT(A3:B3),C2+A3-B3,"")

Copy this formula down as far as necessary. If you choose to enter debits
as negative numbers you will need to adjust the formulas a little.

There are many other approachs