Equations

[Brian McGuire]

I am attempting to write an if function that I want to run
the whole length of a column. Example, this function
=IF(F1>200,"4160",IF(F1>1,"460",IF(F1>0,"115",(D1*F1))))

I want it to run for around 80 rows, and I want the rows
to change themselves, i.e.

=IF(F2>200,"4160",IF(F2>1,"460",IF(F2>0,"115",(D2*F2))))

would come up automatically and wouldnt require me to
manually change the cell location every time. If there is
a way to do this, someone please let me know. Thanks.

 

[Frank Isaacs]

Just copy and paste the formula into the row (or rows) below. Excel will
take care of it for you, since the references are "relative" references. (An
absolute reference, which would refer to cell F1 ALWAYS, is $F$1.)

You can also select the cell and drag the bottom right corner handle down as
far as you want, which will fill the formula down.

A third method is to select the cell, and all the ones below it you wish to
fill to, and press Ctrl-D (for "down") to fill down the formula.
--
HTH -

-Frank
Microsoft Excel MVP
Dolphin Technology Corp.
http://vbapro.com