On Monday 01 January 2007 01:42, Kerry Shue wrote (regarding [users] help with a formula): > 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... >
Hi Kerry, Assuming that the row 1 has the headings of "payment" "deposit" and "balance" in colums A, B and C respectively, and also assuming that you enter the value of the "opening balance" of 100 in cell C2, here is a formula which has NO error checking -does not check for validity of the contents of the cells, or signs, or any thing else- and is rather simplistic. Put this formula into cell C3: "=C2+B3-A3", without the quotes. Then, copy the contents of cell C3 (press Control-C) and paste into all cells below C3 (highlight all the cells below C3, and press Control-V). See if this does the job for you - as I said, it is very rudimentary, and has NO error, or bounds checking. If this does what you want, cheers! Else, email either the list, or me, off the list, and we can see what can be done. -- Pradeep Srinivas Bangalore, India --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
