COMPUTE CHANGE IN PRICE BETWEEN CELLS IN A ROW

  • Thread starter Thread starter Steven R. Berke
  • Start date Start date
S

Steven R. Berke

I have a list of weekly prices for three years in column B starting a
Cell B2 and ending cell A177. I would like to have a formula which
calculate the percentage change between the figure in cell A2 and the
figure in cell A3. Then I would like to be able to copy the formula in
cell A3 down to cell A177 to get the percent change between the figure
for all the rest of the cells.
 
Steven,

It depends where you measure the change from. For instance, if A2 holds 25
and A3 holds 20, then the movement could be -20% if measuring from 25, and
25% if measuring form the 20.

For this, I will assume we are measuring the change from A2. The formula
then becomes
=1-(A2/A3)
and format the result cell as percentage.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Steven

You have mis-matched your A's and B's so I will make some assumptions.

You have a list of prices in B2 down to B177.

You wish to know the percentage increase from one week to the next.

In A3 enter =(B3-B2)/B2 and double-click on the fill-handle at bottom right
corner of A3 to copy down.

Gord Dibben XL2002
 
Back
Top