copy formula only

  • Thread starter Thread starter Steve Fletcher
  • Start date Start date
S

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
 
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
 
Back
Top