View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default NEED HELP ON FORMULA!

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

--
Regards
Frank Kabel
Frankfurt, Germany


JIM wrote:
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