Beginner question

T

Tom.

I need to copy and a paste a formula that will calculate the same thing
for a large amount of data. My problem is I don't know how to copy a
formula so that it will use the cells I need it to. My original formula
is something like, (O3+O4*3)/4 and when I copy it down to the next line
excel will make the formula (O4+O5*3)/4. What I need to know is how to
make it skip to (O5+O6*3)/4, then the next line down (O7+O8*3)/4, then
(O9+O10*3)/4 and so on.
 
J

JMB

One possibility. Assuming your column of data is in O3:O100 (change as
necessary) and you are entering the formula in cell N1 (again change as
necessary):

=(INDEX($O$3:$O$100,(ROW()-ROW($N$1))*2+1)+INDEX($O$3:$O$100,(ROW()-ROW($N$1))*2+2)*3)/4
 

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

Top