Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blank cells not to compute | Excel Discussion (Misc queries) | |||
whole price sheet change | Excel Worksheet Functions | |||
calculate % change in price for each of 200+ products | Excel Discussion (Misc queries) | |||
base price list compute on to another price list? on excel work sh | Excel Discussion (Misc queries) | |||
How do I calculate the change in stock price in excel. | Excel Discussion (Misc queries) |