Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
FORMULA
On a spreadsheet I have filled cells B1thru B5 with daily quotes on a
particular stock. In cell B6, I want to express the relative growth for that five day period of time I know there is a simple formula, but I can't see how to do it. I am brand new to Excel. -- KEN |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
FORMULA
Enter this in B6
=B5/B1 this will show you how the fraction showing the increase/decrease of value in B5 as compared to B1... so if B1 increased from 100 to 120 in B5, B6 will show you 1.2 You can format it as % to see 120%... or have =B5/B1 - 1 to see the % growth (20%)... basically use * to multiply, / to divide and + or - normally as you would do on paper... replace numbers with the cell name like I have done with B1 and B5... If this is not what you want then show us how you will calculate in on paper... "KC" wrote: On a spreadsheet I have filled cells B1thru B5 with daily quotes on a particular stock. In cell B6, I want to express the relative growth for that five day period of time I know there is a simple formula, but I can't see how to do it. I am brand new to Excel. -- KEN |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
FORMULA
SHEELOO,
THANKS FOR THE INFO...HELPED MY SYNAPSES TO CONNECT. KEN -- KEN "Sheeloo" wrote: Enter this in B6 =B5/B1 this will show you how the fraction showing the increase/decrease of value in B5 as compared to B1... so if B1 increased from 100 to 120 in B5, B6 will show you 1.2 You can format it as % to see 120%... or have =B5/B1 - 1 to see the % growth (20%)... basically use * to multiply, / to divide and + or - normally as you would do on paper... replace numbers with the cell name like I have done with B1 and B5... If this is not what you want then show us how you will calculate in on paper... "KC" wrote: On a spreadsheet I have filled cells B1thru B5 with daily quotes on a particular stock. In cell B6, I want to express the relative growth for that five day period of time I know there is a simple formula, but I can't see how to do it. I am brand new to Excel. -- KEN |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
FORMULA
Hi,
Another way to look at this, which is equivalent, would be =(A5-A1)/A1 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "KC" wrote: On a spreadsheet I have filled cells B1thru B5 with daily quotes on a particular stock. In cell B6, I want to express the relative growth for that five day period of time I know there is a simple formula, but I can't see how to do it. I am brand new to Excel. -- KEN |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|