Excel formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Susan,

Very clear!

assuming Jan in A1, Feb in B1, Mar in C1, etc. enter this in B2

=(B1-A1)/A1

and format as a a percentage, then just copy across

If you want to setup for the year, use

=IF(B1="","",(B1-A1)/A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top