Peter,
enter the formula into the top cell on column c.
Then right click on the cell, copy...
go to the next cell in the C column and press the left mouse button and while pressed, highlight the column to the bottom, then press the right mouse button and select paste.
This should copy the formula to each of the cells in the C column.
|