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

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

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 <(E-Mail Removed)> 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