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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
