ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   COMPUTE CHANGE IN PRICE BETWEEN CELLS IN A ROW (https://www.excelbanter.com/excel-programming/283894-compute-change-price-between-cells-row.html)

Steven R. Berke

COMPUTE CHANGE IN PRICE BETWEEN CELLS IN A ROW
 
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.

Bob Phillips[_6_]

COMPUTE CHANGE IN PRICE BETWEEN CELLS IN A ROW
 
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 R. Berke" wrote in message
om...
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.




Gord Dibben

COMPUTE CHANGE IN PRICE BETWEEN CELLS IN A ROW
 
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


On 28 Nov 2003 16:40:35 -0800, (Steven R. Berke)
wrote:

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.




All times are GMT +1. The time now is 03:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com