Stan, it isn't helpful to post a reply as a new thread. The easiest way, probably, to copy the formula is to select the entire range in which you wish to have the formulas (including the cell containing the formula) and use Edit >Fill >Down.
Stan Hutchinson wrote: > > "Thanks, that is what I require ( I think ) but does copy to all rows mean > typing the formula in every row to row 368 to obtain an annual total > What I have read does not seem to operate at this level" > > Pradeep Srinivas wrote: > > On Sunday 06 May 2007, Stan Hutchinson wrote (regarding [users] Calc): >> How can I get the row number to make a formula for Credit in column A, >> Debit in column B and Total in column C simplistically >> >> C this row = C previous row plus A this row minus B this row >> >> so that it does not have to be entered at every row >> >> shandih > > > Hi, > > Unless I misunderstand you, the requirement can be met fairly > simplistically > by this formula: > > Assuming C1 is the heading row, and C2 is the first row where you have the > details, then C3 becomes the first row where you can automate the > process... > Therefore, > in C3 put in "=C2 + A3 - B3" > and copy that to all the rows below C3. > > If this is not what you want, please explain the situation once again to > the > list. > > Please respond to the list - NOT to me. > > -- > Pradeep Srinivas > Bangalore, India > > -- View this message in context: http://www.nabble.com/Calc-tf3699517.html#a10345450 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
