Beginner question
 

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.


--
Tom.
------------------------------------------------------------------------
Tom.'s Profile: http://www.excelforum.com/member.php...o&userid=33766
View this thread: http://www.excelforum.com/showthread...hreadid=535367

Beginner question
 

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

"Tom." wrote:


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.


--
Tom.
------------------------------------------------------------------------
Tom.'s Profile: http://www.excelforum.com/member.php...o&userid=33766
View this thread: http://www.excelforum.com/showthread...hreadid=535367