NEED HELP ON FORMULA!

J

JIM

I have about 1000 numbers that represent the monthly
closes of a stock. Is there a way in excel to make a
formula that would show in the next column the gain or
loss by dividing one number by the previous?

JIM
 
F

Frank Kabel

Hi
maybe in B2 the following formula
=A2/A1-1
and format as percentage and copy down for the whole row
 
Top