Dragging a calculation

[Joel]

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

 

[Mike H]

Hi

Note the dollar signs added to your formula to make the reference absolute

=IF(D8="","",(D8*Template!$T$14))

Mike

 

[Gord Dibben]

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