On 2010-06-08 6:05 PM, Brian Barker wrote: > At 06:55 08/06/2010 -0400, William Drescher wrote: >> 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)
> Taking your example of the result being in cell I2, enter: > =OFFSET(I2;0;-1)-AVERAGE(OFFSET(I2;0;-4):OFFSET(I2;0;-2)) Nice one Brian! Didn't know about OFFSET function... --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
