Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi One and all
This is a real simple question for those in the know. I have a formula in a cell that I want to drag down so I don't have to write the formula 2000 times. This I can do but there is part of the formula that I don't wish to change. =IF(D6="","",(D6*Template!T14)) Then next formula should be =IF(D7="","",(D7*Template!T14)) Then it sould be =IF(D8="","",(D8*Template!T14)) Has you can see I don't want the T14 Cell to change but the rest I do Thanks Joel -- N/A |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dragging | Excel Worksheet Functions | |||
About this dragging... | Excel Discussion (Misc queries) | |||
dragging | Excel Discussion (Misc queries) | |||
Dragging Across | Excel Discussion (Misc queries) | |||
VLOOKUP dragging down | Excel Worksheet Functions |