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

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

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