How can I set up a formula in Excel that will perform the same operation on pairs of cells?

Update: I have a column of figures which are monthly stock market indices. I want to find the monthly returns. For this, the formula is to divide one cell by the previous cell and subtract 1. So I'd do, for example, C7/C6-1. The cell below would have C8/C7-1, then C9/C8-1. Make sense? I can find instructions on how... show more I have a column of figures which are monthly stock market indices. I want to find the monthly returns. For this, the formula is to divide one cell by the previous cell and subtract 1. So I'd do, for example, C7/C6-1. The cell below would have C8/C7-1, then C9/C8-1. Make sense?

I can find instructions on how to apply the same operation to an entire column, but not this. Cheers.
2 answers 2