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

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

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