I'm a total newcomer to spreadsheets but I think/hope a spreadsheet is what I need to fulfil a very simple requirement.
I want to maintain a simple balance of income and outgoings, e.g.:-
Date Description Credit Debit Balance 1/1/2012 Monthly charge £200.00 -£200.00 5/1/2012 Received cheque £200.00 £0.0 21/1/2010 Miscellanous expense £5.00 -£5.00
.... etc.
I can manage the various data entry columns in Gnumeric but what formula do I need in the Balance column?
Firstly I can't find the syntax for "all cells to the end", all the Help seems to tell me is how to enter a range, i.e. C2:C12 means the range from C2 to C12, but how do you say "to the end"?
Secondly how do you get a running balance without having to re-enter the formula in the Balance column for every row you enter?