Home |
Search |
Today's Posts |
#1
|
|||
|
|||
month to month % change
I am VERY new to spreadsheets! Is there a formula that will calculate the %
change in my investments from one entry to the next? In other words, if January's value of a stock is $10, and February's value is $12, and March's value is $6, can I get a cell that will show a 20% increase for Feb, and change to (50%) loss when I enter March's value? I hope this is clear! Thanks for any help! Susan -- Susan |
#2
|
|||
|
|||
See response in .newusers.
there is no need to post to each group separately, we tend to read most groups. -- HTH RP (remove nothere from the email address if mailing direct) "Susan" wrote in message ... I am VERY new to spreadsheets! Is there a formula that will calculate the % change in my investments from one entry to the next? In other words, if January's value of a stock is $10, and February's value is $12, and March's value is $6, can I get a cell that will show a 20% increase for Feb, and change to (50%) loss when I enter March's value? I hope this is clear! Thanks for any help! Susan -- Susan |
#3
|
|||
|
|||
Let's say that you have the month in column A, and the stock's ending value
in the same row in column B. In this example, January's info is in row 2, Feb in row 3, etc. In cell C3, enter =B3/B2-1 After pressing the Enter key, but with cell C3 still selected, click on the % icon on the toolbar. Then copy this cell down to the other cells in the column where you want the caclulation "Susan" wrote: I am VERY new to spreadsheets! Is there a formula that will calculate the % change in my investments from one entry to the next? In other words, if January's value of a stock is $10, and February's value is $12, and March's value is $6, can I get a cell that will show a 20% increase for Feb, and change to (50%) loss when I enter March's value? I hope this is clear! Thanks for any help! Susan -- Susan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add one month to the previuos month | Excel Discussion (Misc queries) | |||
Month Year Date Format | Excel Worksheet Functions | |||
Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
How to extract month number from month name | Excel Discussion (Misc queries) | |||
PivotTable - Count by Month | Excel Worksheet Functions |