View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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