copy formula only

[Steve Fletcher]

When I copy a formula down the column the value gets repeated all the way
down too . How can I only paste the formula so as the cells stay blank
until related cells are filled in to make the calculations.
Thanks
Steve

 

[Don Guillett]

if(relatedcell="","",relatedcellformula)

 

[Gord Dibben]

Steve

Example only, your data and formulas will differ.

Columns A has numeric data. Column B is blank but awaiting data.

You want the product of A1 and B1 and on down the columns.

In C1 enter =IF(B1="","",A1*B1) then drag/copy down Column C

The idea is to have a qualifier in the formula. If a certain parameter is not
met, then leave C looking blank otherwise show the results of the calculation.

If you have a particular formula you need help with, post it.

Gord Dibben XL2002