Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging a calculation
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging a calculation
Hi
Note the dollar signs added to your formula to make the reference absolute =IF(D8="","",(D8*Template!$T$14)) Mike "Joel" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging a calculation
Add the dollar signs to make T14 absolute.
=IF(D6="","",(D6*Template!$T$14)) For more see help on relative and absolute references. Gord Dibben MS Excel MVP On Wed, 12 Dec 2007 09:01:01 -0800, Joel wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |