NEED HELP ON FORMULA!

  • Thread starter Thread starter JIM
  • Start date Start date
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
 
Hi
maybe in B2 the following formula
=A2/A1-1
and format as percentage and copy down for the whole row
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need to make cell blank if no data in previous cell 1
Excel Sumproduct 0
Need formula to count blank cells 5
Excel "price-stop" formula 1
Excel Need Countifs Formula Help 0
Copying a formula to a range 2
Referring to "previous cell" in a formula in a "varying current ce 2
Help needed 0

Back
Top