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. |
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 |