Re: [users] help with a formula

[Joe Conner]

I have addressed you directly and attached a small spreadsheet that will do what you want. In essence, in cell D3 you can put "=D2-B3+C3" without the quotes, and then carry this

pattern downward.

Happy New Year.
Joe

Kerry Shue wrote:

i have this setup
payment          deposit            balance
                                              100.00
20                                            80.00
20                                            60.00
                        40.00              100.00
10                                             90.00
10                                            80.00
                          20.00             100.00

i keep my bank balance on a spreed sheet, can you tell me what formula i need 
to use in the balance column to do this function..keeping the balance when ever 
i deduct a payment and when i have a deposit to keep a running total so that i 
dont have to keep the balance manually with  my calculater...i know how to add 
columns and ohter funtions but i cant figure this one out...and dont know the 
right question to ask in the help page...

thank you

Kerry

KERRY SHUE.ods
Description: application/vnd.oasis.opendocument.spreadsheet

smime.p7s
Description: S/MIME Cryptographic Signature