| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Linear Mode
