On 2010-06-08 6:55 AM, william drescher wrote: > I am computing a moving average and comparing it to a current value > (looking at the current weights of dogs compared to their average over > the prior 3 months). > So my cell formula is (in column I): > =h2 - ((e2 + f2 + g2)/3) > > Each month I insert a new column just before the average column, then I > need to redo this formula. > > How can I write the formula so that it uses > = 1_cell_to_the_left - (4_cells_to_the_left + 3_cells_to_the_left + > 2_cell_to_the_left)/3)
I think you only need to change the option: Tools > Options > Openoffice.org Calc > General and check "Expand references when new columns/rows are inserted" ? --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
