Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Equations
I am attempting to write an if function that I want to run
the whole length of a column. Example, this function =IF(F1200,"4160",IF(F11,"460",IF(F10,"115",(D1* F1)))) I want it to run for around 80 rows, and I want the rows to change themselves, i.e. =IF(F2200,"4160",IF(F21,"460",IF(F20,"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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Equations
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 "Brian McGuire" wrote in message ... I am attempting to write an if function that I want to run the whole length of a column. Example, this function =IF(F1200,"4160",IF(F11,"460",IF(F10,"115",(D1* F1)))) I want it to run for around 80 rows, and I want the rows to change themselves, i.e. =IF(F2200,"4160",IF(F21,"460",IF(F20,"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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Equations appear as text | Excel Discussion (Misc queries) | |||
Trendline Equations | Excel Discussion (Misc queries) | |||
Equations | Excel Discussion (Misc queries) | |||
Variable equations help please | Excel Worksheet Functions | |||
Trendline Equations | Charts and Charting in Excel |