software

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: www.excelforum.com/member.php...oamp;userid=33766
View this thread: www.excelforum.com/showthread...hreadid=535367One 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

quot;Tom.quot; wrote:

gt;
gt; I need to copy and a paste a formula that will calculate the same thing
gt; for a large amount of data. My problem is I don't know how to copy a
gt; formula so that it will use the cells I need it to. My original formula
gt; is something like, (O3 O4*3)/4 and when I copy it down to the next line
gt; excel will make the formula (O4 O5*3)/4. What I need to know is how to
gt; make it skip to (O5 O6*3)/4, then the next line down (O7 O8*3)/4, then
gt; (O9 O10*3)/4 and so on.
gt;
gt;
gt; --
gt; Tom.
gt; ------------------------------------------------------------------------
gt; Tom.'s Profile: www.excelforum.com/member.php...oamp;userid=33766
gt; View this thread: www.excelforum.com/showthread...hreadid=535367
gt;
gt;