ExcelBanter - NEED HELP ON FORMULA!

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - NEED HELP ON FORMULA! (https://www.excelbanter.com/excel-programming/305048-need-help-formula.html)

JIM

NEED HELP ON FORMULA!

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

Frank Kabel

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

All times are GMT +1. The time now is 05:23 PM.