Re: Formula

Eustace wrote:
> 
> I want each cell of column E to display the average of the corresponding 
> cells of column B and C (that is (B+C)/2). How do I do this?

I would put the formula in the top cell you want, for example if the top 
row you want averaged is row 3, then put (B3+C3)/2  into Cell E3.  Now 
you can copy this to the rest of the cells. Copy / Paste   -   or select 
cell E3 and hover the mouse cursor in the lower right corner of cell E3 
until a + appears, then click and drag this down.

Or you could put @AVG(B3..C3) in E3 and copy it down as above.

Hope this helps.

Tim

I want each cell of column E to display the average of the corresponding 
cells of column B and C (that is (B+C)/2). How do I do this?