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)
bill
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
